Designer Guide

10.5
- 10.4.1
- 10.4.0
- 10.2 HotFix 2
- 10.2 HotFix 1
- 10.2
- 10.1.1
- 10.1
- 10.0

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.

Propagating Implicit Dependencies