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.
Note: 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.