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

Developer Mapping Guide

Developer Mapping Guide

Troubleshooting Dynamic Mappings

Troubleshooting Dynamic Mappings

Consider the following troubleshooting tips when you design and test dynamic mappings:
The dynamic ports in my mapping include a column with XML data type, and the mapping failed.
You cannot propagate XML data through a mapping if any of the following conditions are true:
  • You configure the Read or Write transformation to get columns from the data source.
  • You configure the Write transformation to get columns from the data flow.
  • You configure the data obect for the target to create or replace the target at run time.
My dynamic mapping failed with run-time errors for parameters and links. I would like to make sure that the parameters and links successfully resolve before I run the mapping.
When you run a dynamic mapping, the Data Integration Service compiles the mapping to complete the following tasks:
  • Resolve parameter values.
  • Expand dynamic ports and convert generated ports to static ports.
  • Link static ports.
  • Resolve run-time links to connect the ports.
You can view the optimized mapping to see the compiled version of a mapping. Right-click an empty area in the mapping editor and click
Show Optimized Mapping
. The Data Integration Service generates the optimized mapping. You can review the optimized mapping, fix any issues, and then run the mapping.
The following image shows a dynamic mapping that contains transformations with dynamic ports:
The mapping contains a Read transformation, two Expression transformations, and a Write transformation. The two Expression transformations have two dynamic ports.
The following image shows the compiled version of the dynamic mapping in which the generated ports are converted to static ports and are linked:
The optimized mapping contains a Read transformation, an Expression transformation, and a Write transformation. The generated ports are converted to static ports and the links are resolved between the ports in the optimized mapping.

0 COMMENTS

We’d like to hear from you!