asked **marvit ** September 20, 2014 08:04 AM
informatica

How to lookup is acting as both active and passive ? how is it possible?

add comment

answered By vishnoiprem 0

Both Lookup transformations are passive

A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation."

And

An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition."

Therefore, the Lookup transformations work as passive but not as active transformations.

A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation."

And

An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition."

Therefore, the Lookup transformations work as passive but not as active transformations.

flag

Write A Tutorials

Question tags

Similar questions

Follow this question

Follow informatica category

Question tags

informatica
× 1

Asked
**3 years and 5 months ago ago**

Number of Views -594

Number of Answers -1

Last updated

**3 years and 2 months ago ago**

Number of Views -594

Number of Answers -1

Last updated

Similar questions