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

Step 1. Configure the Read Transformations

Step 1. Configure the Read Transformations

Configure the Read transformations to fetch column and metadata changes directly from the dynamic sources at run time.
  1. Add two Read transformations that represent the CUSTOMER and ORDERS relational data objects.
  2. Configure the Read_CUSTOMER transformation to fetch column and metadata changes directly from the sources at run time.
    1. Select the Read_CUSTOMER transformation.
    2. In the
      Properties
      view, click the
      Data Object
      tab.
    3. Select
      At run time, get data object columns from the data source
      .
      The following image shows the Data Object tab settings of the Read_CUSTOMER transformation:
      The Data Object tab in the Properties view of the Read transformation shows the data object name. The Data Object tab also has an option that you select to get the data object columns from the data source at run time.
  3. Configure the Read_ORDERS transformation to fetch column and metadata changes directly from the sources at run time.
    1. Select the Read_ORDERS transformation.
    2. In the
      Properties
      view, click the
      Data Object
      tab.
    3. Select
      At run time, get data object columns from the data source
      .

0 COMMENTS

We’d like to hear from you!