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

Multiple-Record Data Maps and Group Source Processing

Multiple-Record Data Maps and Group Source Processing

If a data source has multiple record types, the PowerExchange data map defines a record and a table for each unique record type. The table represents the relational view of the related record. To maintain the relationships among IMS record types, PowerExchange uses the segment information that you import from an IMS DBD into the multiple-record data map.
In PowerCenter Designer, you can import a data map with multiple record types to create a single PowerCenter source definition. To include all record types in the source definition, import the data map as a multiple-record data map.
To import the data map as a multiple-record data map, select
Multi-Record Datamaps
in the
Import from PowerExchange
dialog box. If you import a multiple-record data map, the source definition has a section for each table in the data map.
PowerExchange uses group source processing to process multiple-record data maps. When PowerExchange performs group source processing, it reads data from the same physical source in a single pass.