PowerCenter
- PowerCenter 10.4.1
- All Products
Merge Type | Integration Service Behavior |
---|---|
No Merge | The Integration Service generates one target file for each partition. If you stage the files, the Integration Service transfers the target files to the remote location at the end of the session. If you do not stage the files, the Integration Service generates the target files at the remote location. |
Sequential Merge | Enables the Is Staged option in the connection object. The Integration Service creates one output file for each partition. At the end of the session, the Integration Service completes the following actions:
|
File List | If you stage the files, the Integration Service creates the following files:
At the end of the session, the Integration Service transfers the files to the remote location. If the individual target files are in the Merge File Directory, file list contains relative paths. Otherwise, the file list contains absolute paths. If you do not stage the files, the Integration Service writes the data for each partition at the remote location and creates a remote file list that contains a list of the individual target files. Use the file list as a source file in another mapping. |
Concurrent Merge | If you stage the files, the Integration Service concurrently writes the data for all target partitions to a local merge file. At the end of the session, the Integration Service transfers the merge file to the remote location. The Integration Service does not write to any intermediate output files. If you do not stage the files, the Integration Service concurrently writes the target data for all partitions to a merge file at the remote location. |