Developer Mapping Guide

Back Next

Dynamic Mapping

Create a mapping m_CustomerLoad and configure the following dynamic mapping functionality:

Read transformations that can read from dynamic sources

Dynamic ports in the downstream transformations that can pass new and changed columns

Write transformation that can write to dynamic targets

Run-time links that can connect ports to the Write transformation at run time

When you run the mapping, the Data Integration Service performs the following tasks:

Fetches the structure of the data objects and metadata changes in the source files.

Passes the new and changed columns to each transformation through dynamic ports.

Connects the new and changed ports to the Write transformation.

Writes the transformed data to the target.

The following image shows the objects in the mapping:

The mapping contains the following objects:

Read_CUSTOMER: Read transformation that represents the relational source CUSTOMER. The relational table contains a separate row for each customer.
Read_ORDERS: Read transformation that represents the relational source ORDERS. The relational table that contains a separate row for each customer order.
Join_CustomerOrders: Joiner transformation that joins the CUSTOMER and ORDERS sources.
Agg_CustomerOrders: Aggregator transformation that aggregates the total customer orders.
Write_CUSTOMERSUMMARY: Write transformation that represents the relational target CUSTOMERSUMMARY. The relational table contains a column for the mapping to write the aggregated value for total orders grouped by customer.