Multidomain MDM
- Multidomain MDM 10.3
- All Products
Property
| Description
|
---|---|
Display Name
| Name for the column that will display in the
Hub Console .
|
Length
| You can only increase the length of a CHAR, VARCHAR, NCHAR, or NVARCHAR2 field.
|
Default
| Used if no value is provided for the column but the column cannot be NULL.
Enabling Default does not have any affect on records that were loaded before Default was enabled. Existing NULL values remain NULL. Reload the data, preferably from the staging table, to ensure the values in the column are not NULL.
|
Trust
| Specifies whether a column is a trusted column.
You need to synchronize metadata if you enable trust. If you enable trust for a column on a table that already contains data, you are warned that your trust settings have changed and that you need to run the trust Synchronization batch job in the Batch Viewer tool before doing any further loads to the table.
Informatica MDM Hub automatically ensures that the Synchronization job is available in the Batch Viewer tool.
You must execute the synchronization process before you run any more Load jobs. Otherwise, the trusted values used to populate the column will be incorrect.
If you disable trust, columns from some of the underlying metadata tables are removed and results in loss of data.
If you inadvertently disable trust and save that change, you should correct your error by enabling trust again and immediately running the Synchronization job to recreate the metadata.
|
Unique
| Specifies whether a column has unique values. Enable the Unique property if the column should contain unique values. If you enable the Unique property for a column, ensure that duplicate values do not exist in the column. You cannot enable the Unique property for a column that contains duplicate values. Do not use the Unique property, particularly on base objects that might be merged.
|
Validate
| Specifies whether a column needs to be validated. If you disable validation, metadata is lost for the associated column.
|
Putable
| Enable the Putable property for system columns into which you want to put data (insert or update) using
SIF requests and by using batch jobs run through the Hub Console. Applies to any system column except ROWID_OBJECT, CONSOLIDATION_IND, HUB_STATE_IND, LAST_ROWID_SYSTEM, and CM_DIRTY_IND.
|