PowerCenter All Products
Type of source input. You can choose the following types of source input:
You cannot use a command to generate XML source data.
Concurrent read partitioning
Order in which multiple partitions read input rows from a source file. You can choose the following options:
Source File Directory
Directory name of flat file source. By default, the Integration Service looks in the service process variable directory, $PMSourceFileDir, for file sources.
If you specify both the directory and file name in the Source Filename field, clear this field. The Integration Service concatenates this field with the Source Filename field when it runs the session.
You can also use the $InputFile
Namesession parameter to specify the file location.
Source File Name
File name, or file name and path of flat file source. Optionally, use the $InputFile
Namesession parameter for the file name.
The Integration Service concatenates this field with the Source File Directory field when it runs the session. For example, if you have “C:\data\” in the Source File Directory field, then enter “filename.dat” in the Source Filename field. When the Integration Service begins the session, it looks for “C:\data\filename.dat”.
By default, the Workflow Manager enters the file name configured in the source definition.
Source File Type
You can choose the following source file types:
Type of source data the command generates. You can choose the following command types:
Command used to generate the source file data.
Truncate string null
Strips the first null character and all characters after the first null character from string values.
Enable this option for delimited flat files that contain null characters in strings. If you do not enable this option, the PowerCenter Integration Service generates a row error for any row that contains null characters in a string.
Default is disabled.