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 2. Configure the Joiner Transformation

Step 2. Configure the Joiner Transformation

Add a Joiner transformation to the mapping and configure dynamic ports to receive any new and changed columns from the Read transformation. Define a join condition to join the two source tables CUSTOMER and ORDERS.
  1. Add a Joiner transformation Join_CustomerOrders to the mapping.
  2. Create dynamic ports in the Joiner transformation:
    1. From the Read_Customer transformation, drag the All Ports group to the Master group in the Joiner transformation.
      The Developer tool creates a dynamic port From_Read_CUSTOMER in the Master group and the Output group.
    2. From the Read_Orders transformation, drag the All Ports group to the Detail group in the Joiner transformation.
      The Developer tool creates a dynamic port From_Read_ORDERS in the Detail group and the Output group.
    The dynamic ports include all ports from the corresponding Read transformations as generated ports.
    The following image shows the All Ports groups from the Read transformations linked to the two dynamic ports in the Joiner transformation:
    The mapping contains the Read_CUSTOMER, Read_ORDERS, and the Join_CustomerOrders transformations. The All Ports groups from the Read transformations are linked to the two dynamic ports in the Joiner transformation.
  3. In the
    Properties
    view, click the
    Join
    tab.
  4. Click the
    New
    button, and define the join condition as C_CUSTKEY = O_CUSTKEY_DTL.
    The following image shows the
    Join
    tab with the join condition defined:
    The Join tab in the Properties view of the Joiner transformation shows the join condition.

0 COMMENTS

We’d like to hear from you!