Designer Guide

Back Next

Example

You have the following mapping:

In this mapping, the Items source connects to the SQ_ITEMS Source Qualifier transformation, which connects to an Aggregator transformation. The Aggregator transformation connects to a Lookup transformation, an Expression transformation, and a target.

The MANUFACTURER_ID port in the Aggregator transformation links to the IN_MANUFACTURER_ID port in the Lookup transformation. The Lookup transformation uses the following lookup condition:

MANUFACTURER_ID = IN_MANUFACTURER_ID

You change the datatype of the MANUFACTURER_ID port from integer to decimal in the Aggregator transformation. You choose to parse conditions to infer dependencies, and then propagate the datatype change. The Designer performs the following tasks:

Updates link path dependencies.
The Designer updates the ports in the link path, changing the datatype of the IN_MANUFACTURER_ID port in the Lookup transformation to decimal.

Identifies dependent ports.
The Designer parses the lookup condition and identifies the MANUFACTURER_ID port in the Lookup transformation as a dependent port.

Updates implicit dependencies.
The Designer changes the datatype of the MANUFACTURER_ID port in the Lookup transformation to decimal.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Example

Example