PowerCenter
- PowerCenter 10.4.1
- All Products
Attribute | Description |
---|---|
Merge Type | Type of merge that the Integration Service performs on the data for partitioned targets. When merging target files, the Integration Service writes the output for all partitions to the merge file or a command when the session runs. You cannot merge files if the session uses an external loader or a message queue. |
Merge File Directory | Location of the merge file. Default is $PMTargetFileDir. |
Merge File Name | Name of the merge file. Default is target name.out . |
Append if Exists | Appends the output data to the target files and reject files for each partition. Appends output data to the merge file if you merge the target files. You cannot use this option for target files that are non-disk files, such as FTP target files. If you do not select this option, the Integration Service truncates each target file before writing the output data to the target file. If the file does not exist, the Integration Service creates it. |
Output Type | Type of target for the session. Select File to write the target data to a file target. Select Command to send target data to a command. You cannot select Command for FTP or queue target connection. |
Header Options | Create a header row in the file target. |
Header Command | Command used to generate the header row in the file target. |
Footer Command | Command used to generate a footer row in the file target. |
Merge Command | Command used to process merged target data. |
Output File Directory | Location of the target file. Default is $PMTargetFileDir. |
Output File Name | Name of target file. Default is target name partition number.out . You can also use the session parameter, $OutputFileName , as defined in the parameter file. |
Reject File Directory | Location for the target reject files. Default is $PMBadFileDir. |
Reject File Name | Name of reject file. Default is target name partition number.bad . You can also use the session parameter, $BadFile Name , as defined in the parameter file. |
Command | Command used to process the target output data for a single partition. |