Developer Mapping Guide > How to Develop and Run a Dynamic Mapping > Developing and Running Dynamic Mappings
  

Developing and Running Dynamic Mappings

Develop a dynamic mapping to manage changes to source metadata and to reuse the data integration logic for different sources and targets. Run the dynamic mapping for same or different sources and targets that might have metadata changes.
The following table lists the high-level tasks to develop and run a dynamic mapping. The tasks and the order in which you perform the tasks depend on the mapping scenario and the transformations that you plan to use in the mapping.
Task
Reference
Create a mapping and add mapping objects.
Adding Objects to a Mapping
Configure dynamic sources for the Read or Lookup transformations to get metadata changes from flat file or relational sources at run time.
Create dynamic ports in transformations and link ports.
Define input rules for dynamic ports to determine which generated ports to create.
  • - Define input rules to include or exclude ports.
  • - Rename the generated ports.
  • - Optionally, reorder generated ports.
Configure the transformations.
Refer to the Informatica Developer Transformation Guide for details to configure transformations in the mapping.
Optionally, create port selectors to use in the transformation logic of Joiner, Lookup, or Expression transformations.
Optionally, create dynamic expressions to use in Expression transformations.
Configure Write transformations to write to dynamic targets as follows:
  • - Define column definitions from an associated data object and get metadata changes from the target file or define columns definitions from the mapping flow of the upstream transformation.
  • - Create or replace target tables at run time for Write transformations that represent relational targets.
Create and configure a run-time link to determine which ports to link at run time.
After you determine where you want to use parameters in the mapping, create and assign parameters.
  • - Configure sources as parameters
  • - Configure targets as parameters
  • - Configure transformation properties as parameters
Validate the mapping.
Validate synchronized data sources and targets in the dynamic mapping.
Compile and run the dynamic mapping.