Developer Mapping Guide

10.2.2
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.1

Back Next

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

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.

To validate the changed mapping, click

Edit

Validate

When the mapping is valid, click

File

Save

to save the mapping.

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.

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.

Click

Window

Show View

Data Viewer

The

Data Viewer

view appears.

In the

Data Viewer

view, click

Run

The

Data Viewer

view runs and displays the data.

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.

Rename Saved Search

Table of Contents

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