Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

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.
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.
  • Select a target schema strategy for the Write transformations that represent relational and Hive 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.