Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Creating target objects at run time with parameter files

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.
  1. In the mapping, create an input parameter:
    1. Select
      data object
      for the parameter type.
    2. Select
      Allow parameter to be overridden at runtime
      .
  2. In the mapping, use the parameter as the target object.
  3. In the task, define the parameter details:
    1. Set the type to
      Single
      .
    2. Select a default data object.
    3. On the
      Schedule
      tab, enter the parameter file directory and file name.
  4. 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.
  5. If you want to change the object, update the parameter value in the parameter file.

0 COMMENTS

We’d like to hear from you!