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
design of staging area?
How to use procedural logic inside infromatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Write the prerequisite tasks to achieve the session partition?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
where to store informatica rejected data? How to extract the informatica rejected data?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is index?how it can work in informatica
Please let me know how to make encryption and decryption with example?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are active and passive transformations?
What are roles and groups and benefits of using them?
What are the different transaction levels available in transaction control transformation?
Can we create a Integration service without a Repository service and vice versa?