Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Implementing Data Masking and Data Subset with IMS Unload File Sources

Implementing Data Masking and Data Subset with IMS Unload File Sources

Implementing Data Masking and Data Subset with IMS Unload File Sources

Sequencing Support in Source and Target Definitions

Sequencing Support in Source and Target Definitions

If you enable multiple-record write operations with sequencing when you import a multiple-record data map into PowerCenter, the resulting source or target definition includes special features to support record sequencing.
The following PowerCenter features support sequencing:
  • The generated primary key and foreign key columns in the table definitions. The keys contain sequence numbers that uniquely identify each row and its parent.
    The source definition includes the following generated columns:
    • DTL_PK_
      tablename
      . Generated for each table. This sequence number serves as a primary key.
    • DTL_FK_
      tablename
      . Generated for each table that corresponds to a non-root record. This sequence number serves as a foreign key.
  • The following metadata extensions on the
    Metadata Extensions
    tab of the
    Edit Tables
    dialog box:
    • Use Sequence Fields. This metadata extension indicates that you selected the
      Use Sequence Fields
      option in the
      Import from PowerExchange
      dialog box.
    • Hierarchy Structure. This metadata extension is a segment of XML code that defines the hierarchy structure of the tables in a source or target definition.