PowerExchange Interfaces for PowerCenter

10.4.0
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

Multiple-Record Writes to Nonrelational Targets

During bulk data movement sessions, PowerExchange can use a multiple-record data map to read data from a nonrelational data source and write the multiple record types in a single pass to a nonrelational target. This process is called a multiple-record write
.

When PowerExchange performs a multiple-record write, it preserves source sequencing information. To enable multiple-record writes with sequencing, select the

Multi-Record Datamaps

and

Use Sequence Fields

options in the

Import from PowerExchange

dialog box for both the source and target definition. When you select these options, PowerExchange generates primary key and foreign key fields for each group in the source and target definitions and also stores metadata about these record relationships in XML format.

You can perform multiple-record writes with the following types of sources and targets:

Source and target IMS unload data sets on z/OS

Any combination of the following types of nonrelational sources and targets:

Sequential or VSAM ESDS, KSDS, or RRDS data sets on z/OS

Files on Linux, UNIX, or Windows

Files on i5/OS

Working with Mappings

Group Processing with Sequencing

Sequencing Support in Source and Target Definitions

Considerations for Sessions that Perform Multiple-Record Writes

Connection Attributes for Multiple-Record Writes

Download Guide