22_-_Recap_of_connected_Look_up_Transformation in Informatica

in #dtube • 7 years ago

In Connected lookup transformation, we connect input and output ports to other transformation in the mapping.
For each input row, the Integration Service queries the lookup source or cache based on the lookup ports and the condition in the transformation.

If the transformation is uncached or uses a static cache, the Integration Service returns values from the lookup query.

If the transformation uses a dynamic cache, the Integration Service inserts the row into the cache when it does not find the row in the cache. When the Integration Service finds the row in the cache, it updates the row in the cache or leaves it unchanged. It flags the row as insert, update, or no change.

The Integration Service passes return values from the query to the next transformation. If the transformation uses a dynamic cache, you can pass rows to a Filter or Router transformation to filter new rows to the target.

If there is no match for the lookup condition, the Integration Service returns the default value for all output ports.

► Watch on DTube
► Watch Source (IPFS)

#dtube-
7 years ago in #dtube by
$0.00
    4 votes
    Reply 1

    Coin Marketplace

    STEEM 0.21
    TRX 0.20
    JST 0.034
    BTC 91782.03
    ETH 3133.14
    USDT 1.00
    SBD 3.00