Configuring a Dynamic Source
You can configure the Read and Lookup transformations in a mapping to dynamically update metadata, including column names, when transformation sources change.
When you configure Read and Lookup transformations for a dynamic mapping, you can use one or more of the following methods:
- Use a parameter as a source
- When you use a parameter value as a source for a Read or Lookup transformation, you choose a parameter name that references a source data object that you defined elsewhere in the repository.
- Configure Read and Lookup transformations to get metadata at run time
- When you configure Read or Lookup transformations to get data object columns from a source at run time, the mapping refreshes the port definitions when the mapping runs.
Using a Parameter as a Source for a Dynamic Mapping
You can use a parameter as a source for a dynamic mapping source object.
1. In the mapping editor, select the source object.
2. In the Properties view, click the Data Object tab.
3. To use different values for the source object between mapping runs, select Parameter in the Specify by list.
4. Click New to create a new parameter, or Browse to choose an existing parameter.
Configuring Sources to Get Metadata Changes at Run Time
You can configure data sources for source objects in mappings to get metadata changes at run time.
When the metadata for data source columns changes after you develop a mapping, the mapping might be out of date. You can configure data sources with an option to get this data at when the mapping runs.
1. In the mapping editor, select the source object.
2. In the Properties view, click the Data Object tab.
3. To dynamically get columns from the data source file at run time, select At run time, get data object columns from the data source.
