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.