On the Data Object tab, you can specify or change the Read transformation source, and make relational, flat file, and customized data object sources dynamic.
You can configure the following properties:
Specify By
To specify source columns and metadata for the Read transformation, select one of the following options:
Value. The Read transformation uses the associated data object to specify source columns and metadata.
Parameter. The Read transformation uses a parameter to specify source columns and metadata.
Data Object
If you created the Read transformation from an existing data object, the field displays the name of the object. Click
Browse
to change the data object to associate with the Read transformation.
At runtime, get data object columns from data source
When you enable this option, the Data Integration Service fetches metadata and data definition changes from source tables to the Read transformation.