Mappings

Back Next

Creating target objects at run time with parameter files

If you use a target object parameter in a mapping, you can create a target at run time using a parameter file.

You include the target object parameter and the name that you want to use in a parameter file. If the target name in the parameter file doesn't exist,

Data Integration

creates the target at run time. In subsequent runs,

Data Integration

uses the existing target.

To create a target at run time using a parameter file, the following conditions must be true:

The mapping uses a flat file, relational, or file storage-based connection.

The mapping is used in a

mapping

task

dynamic mapping

task,

or taskflow.

For file storage-based connections, the parameter value in the parameter file can include both the path and file name. If the path is not specified, the target is created in the default path specified in the connection.

In the mapping, create an input parameter:

Select

data object

for the parameter type.

Select

Allow parameter to be overridden at runtime

In the mapping, use the parameter as the target object.

In the task, define the parameter details:

Set the type to

Single

Select a default data object.

On the

Runtime Options

tab, enter the parameter file directory and file name.

In the parameter file, specify the name of the target object that you want to create.

Precede the parameter name with two dollar signs ($$). For example, you have a parameter with the name TargetObjParam and you want to create a target object with the name MyTarget. You define the runtime value with the following format:

$$TargetObjParam=MyTarget

For file storage-based connector types, include the path in the object name. If you don't include a path, the target is created in the default path specified in the connection.

If you want to change the object, update the parameter value in the parameter file.

Parameter files

Download Guide

Watch

Comments

Cloud Data Integration Homepage