Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Editing Column Properties

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.
  1. Navigate to the column editor for the table that you want to configure.
  2. Acquire a write lock.
  3. 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.
  4. Click the
    Save
    button to save your changes.

0 COMMENTS

We’d like to hear from you!