Mappings

Back Next

Rules and guidelines for parameter files

Data Integration

uses the following rules to process parameter files:

If a parameter isn't defined in the parameter file,

Data Integration

uses the value defined in the task.

If a mapping uses a source or target object parameter that can be overridden at runtime and an existing object is selected in the task, the parameter value in the parameter file can't be null. If the value is null, the task fails.

Data Integration

processes the file top-down.

If a parameter value is defined more than once in the same section,

Data Integration

uses the first value. For example, a parameter file contains the following task section:

[MyProject].[Folder1].[mapping_task1]
$$sourceconn=Oracle
$$filtervariable=ID
$$sourceObject=customer_table
$$targetconn=salesforce
$$sourceconn=ff_2

When mapping_task1 runs, the value of the sourceconn parameter is Oracle.

If a parameter value is another parameter defined in the file, precede the parameter name with one dollar sign ($).

Data Integration

uses the first value of the variable in the most specific scope. For example, a parameter file contains the following parameter values:

[GLOBAL]
$$ffconnection=my_ff_conn
$$var2=California
$var5=North
[Default].[folder5].[sales_accounts]
$$var2=$var5
$var5=south

In the task "sales_accounts," the value of "var5" is "south." Since var2 is defined as var5, var2 is also "south."

If a task is defined more than once,

Data Integration

combines the sections.

If a parameter is defined in multiple sections for the same task,

Data Integration

uses the first value. For example, a parameter file contains the following task sections:

[Default].[Folder1].[MapTask2]
$$sourceparam=Oracle_Cust
 
[Default].[Folder1].[MapTask2]
$$sourceparam=Cust_table
$$targetparam=Sales

When you run MapTask2,

Data Integration

uses the following parameter values:

$$sourceparam=Oracle_Cust

$$targetparam=Sales

The value of a parameter is global unless it is present in a section.

Data Integration

ignores sections with syntax errors.

Parameter files

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Mappings

Mappings

Rules and guidelines for parameter files

Rules and guidelines for parameter files