You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the agent creates the target when you run the task.
To specify the target properties, follow these steps:
Select the Target transformation in the mapping.
On the
Incoming Fields
tab, configure field rules to specify the fields to include in the target.
To specify the target, click the
Target
tab.
Select the target connection.
For the target type, choose
Single Object
or
Parameter
.
Specify the target object or parameter. You must specify a .csv target file name.
To create a target file at run time, enter the name for the target file including the extension, for example,
Accounts.csv
.
If you want the file name to include a time stamp, click
Handle Special Characters
and add special characters to the file name. For example, add the special characters shown here to include all the time stamp information:
Accounts_%d%m%y%T.csv
.
If you enable
Handle Special Characters
, the input and output parameters in Create Target are ignored.
Click
Formatting Options
if you want to configure the formatting options for the file, and click
OK
.
Click
Select
and choose a target object. You can select an existing target object or create a new target object at run time and specify the object name.
The following image shows the Target Object box:
Specify Advanced properties for the target, if needed.