Configuration Guide

10.3 HotFix 1

Back Next

Editing Column Properties

Once columns are added and saved, you can change certain column properties.

After you define a table and save changes, you cannot reduce the length of a CHAR, VARCHAR, NCHAR, or NVARCHAR2 field and change the scale or precision of a NUMBER field.

If you make schema changes after the tables are populated with data, manage such changes to columns in a planned and controlled fashion, and ensure that the appropriate database backups are done before making changes.

Navigate to the column editor for the table that you want to configure.

Acquire a write lock.

You can change the following properties for each column:

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.