Table of Contents

Search

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

Developer Mapping Guide

Developer Mapping Guide

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.
  • 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.

0 COMMENTS

We’d like to hear from you!