Implementing Data Masking and Data Subset with IMS Unload File Sources

Back Next

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.

Rename Saved Search

Table of Contents

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