Developer Transformation Guide

10.4.0
- 10.5.2
- 10.5
- 10.4.1

Back Next

Read Transformation Parameters

You can parameterize some of the properties of a Read transformation and some of the properties of the reusable physical data object that you create the Read transformation from.

When you create a physical data object, you configure the read and write properties. The parameters that you configure for read properties in a physical data object appear in the Read transformation

Data Object Parameters

tab when you add the data object to a mapping.

You can configure parameters for the following Read properties in the physical data object:

Control file directory

Control file name

Default scale

Delimiter

Flat file delimiter

Merge file directory

Source file name

Source file directory

After you add the physical data object to a mapping, you can view the parameters in the

Data Object Parameters

tab of the Read transformation. You can expose these parameters as mapping parameters to override the parameter values at run time.

You cannot nest user-defined parameters within a parameterized source. If the source data object is parameterized, you cannot expose a user-defined parameter as a mapping parameter to override the parameter values at run time. The mapping uses the default value instead.

You can configure the following mapping parameters for the Read transformation:

Connection (relational)

Data object

Link resolution order

Resource name (relational)

Table owner name (relational)

You can view these parameters in the mapping

Data Object Parameters

tab.

Read Transformation

Download Guide

Watch