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

Step 7. Run the Mapping after Changes to the Source Schema

Step 7. Run the Mapping after Changes to the Source Schema

The departments that provide the customer data table and customer order data table add a new column Comments to the tables. View the column changes in the dynamic mapping and validate and rerun the mapping. You can preview the data in the target data object to verify the updated result.
The following table lists the columns and metadata for the updated CUSTOMER table with the new C_COMMENT column:
Name
Native Type
Precision
Scale
C_CUSTKEY
number(p,s)
38
0
C_NAME
varchar2
25
0
C_ADDRESS
varchar2
40
0
C_NATIONKEY
number(p,s)
38
0
C_PHONE
varchar2
15
0
C_ACCTBAL
number(p,s)
10
2
C_MKTSEGMENT
varchar2
10
0
C_COMMENT
varchar2
117
0
The following table lists the columns and metadata for the updated ORDERS table with the new O_COMMENT column:
Name
Native Type
Precision
Scale
O_ORDERKEY
number(p,s)
38
0
O_CUSTKEY
number(p,s)
38
0
O_ORDERSTATUS
varchar2
1
0
O_TOTALPRICE
number(p,s)
10
2
O_ORDERDATE
date
19
0
O_ORDERPRIORITY
varchar2
15
0
O_CLERK
varchar2
15
0
O_SHIPPRIOIRITY
number(p,s)
30
0
O_COMMENT
varchar2
79
0
  1. In the mapping editor, view the changes to the mapping.
    The Read and Write transformations automatically reflect the new columns. The dynamic ports in the Joiner and Aggregator transformations automatically have the new columns C_COMMENT and O_COMMENT from the respective Read transformations.
    The mapping shows the new columns C_COMMENT in the Read_CUSTOMER transformation and the O_COMMENT column in the Read_ORDERS column. The Write transformation reflect the new C_COMMENT column. The dynamic ports in the Joiner and Aggregator transformations automatically have the new columns C_COMMENT and O_COMMENT from the respective Read transformations.
  2. To validate the changed mapping, click
    Edit
    Validate
    .
  3. When the mapping is valid, click
    File
    Save
    to save the mapping.
  4. Click
    Run
    Mapping
    .
    The
    Run Mapping
    window displays the progress of the mapping run. The mapping runs and writes the output to the target file.
  5. In the
    Object Explorer
    view, locate the
    CUSTOMERSUMMARY
    data object in your project and double click the data object.
    The data object opens in the editor.
  6. Click
    Window
    Show View
    Data Viewer
    .
    The
    Data Viewer
    view appears.
  7. In the
    Data Viewer
    view, click
    Run
    .
    The
    Data Viewer
    view runs and displays the data.
  8. Verify that the mapping shows the expected results after the source schema has changed.
    The C_TOTALAMOUNT column displays the aggregated total price of customer orders.

0 COMMENTS

We’d like to hear from you!