how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / eswar
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.
Is This Answer Correct ? | 7 Yes | 26 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
Explain about Informatica server process that how it works relates to mapping variables?
Explain the use of aggregator cache file?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a stored procedure transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
tell me 5 session failure in real time how can you solve that in your project?
what is $$$$?
How do you load alternate records into different tables through mapping flow?
Under what condition selecting sorted input in aggregator may fail the session?
What does update strategy mean, and what are the different option of it?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the issues you have faced in your project? How did you overcome those issues?
How can you define user defied event?
Explain constraint based loading in informatica