Data Integration
- Data Integration
- All Products
Property
| Description
|
---|---|
Connection
| Name of the target connection.
|
Target Type
| Target type, either single object or parameter.
|
Object
| Name of the target object.
In advanced mode, the object name cannot contain the dollar sign character,
$ . The dollar sign is a reserved character for parameters.
|
Formatting Options
| Flat file format options. Opens the
Formatting Options dialog box to define the format of the file.
You can choose either a delimited or fixed-width file type. Default is delimited.
To write to a delimited flat file type, configure the following file format options:
You can use a tab, space, or any printable special character as a delimiter. The delimiter can have a maximum of 10 characters. The delimiter must be different from the escape character and text qualifier.
To write to a fixed-width flat file type, select the fixed-width file format to use. If the list includes multiple fixed-width file formats with the same name, use the project and folder location that's appended to the name to determine the appropriate file format to use. If you do not have a fixed-width file format, click
to create one.
|
Operation
| For file targets, the operation is always Insert.
|
Property
| Description
|
---|---|
Forward Rejected Rows
| Causes the
mapping task to forward rejected rows to the reject file.
If you do not forward rejected rows, the
mapping task drops rejected rows and writes them to the session log.
If you enable row error handling, the
mapping task writes the rejected rows and the dropped rows to the row error logs. It does not generate a reject file. If you want to write the dropped rows to the session log in addition to the row error logs, you can enable verbose data tracing.
|
Thousand Separator
| Thousand separator character. Can be none, comma, or period. Cannot be the same as the decimal separator or the delimiter character.
Field type must be Number. You might also need to update the field precision and scale.
Default is None.
|
Decimal Separator
| Decimal character. Can be a comma or period. Cannot be the same as the thousand separator or delimiter character.
Field type must be Number. You might also need to update the field precision and scale.
Default is Period.
|
Append if Exists
| Appends the output data to the target files and reject files for each partition. You cannot use this option for FTP/SFTP target files.
If you do not select this option, the
mapping task truncates each target file before writing the output data to the target file. If the file does not exist, the
mapping task creates it.
|
Header Options
| Creates a header row in the file target. You can choose the following options:
Default is No Header.
|
Header Command
| Command used to generate the header row in the file target. For example, you can use a command to add the date to a header row for the file target.
|
Footer Command
| Command used to generate the footer row in the file target.
|
Output Type
| Type of target for the task. Select
File to write the target data to a file target. Select
Command to output data to a command.
You cannot select
Command for FTP/SFTP target connections.
|
Output File Name
| File name or file name and path of the output file. By default, the
mapping task names output files after the target object.
|
Output File Directory
| Name of the output directory for a flat file target. By default, the
mapping task writes output files to the target connection directory.
You can also use an input parameter to specify the target file directory.
If you use the service process variable directory $PMTargetFileDir, the task writes target files to the configured path for the system variable. To find the configured path of a system variable, see the pmrdtm.cfg file located at the following directory:
You can also find the configured path for the $PMTargetFileDir variable in the Data Integration Server system configuration details in Administrator.
|
Reject File Directory
| Directory path to write the reject file. By default, the
mapping task writes all reject files to the following service process variable directory:
If you specify both the directory and file name in the
Reject File Name field, clear this field. The
mapping task concatenates this field with the
Reject File Name field when it runs the task.
|
Reject File Name
| File name, or file name and path of the reject file. By default, the
mapping task names the reject file after the target object name: <target name>.bad.
The
mapping task concatenates this field with the
Reject File Directory field when it runs the task. For example, if you have
C:\reject_file\ in the
Reject File Directory field, and enter
filename.bad in the
Reject File Name field, the
mapping task writes rejected rows to
C:\reject_file\filename.bad .
|
Updated March 06, 2023