Interested to Buy Any Domain ? << Click Here >> for more details...
how lookup is acting as both active and passive ?
how is it possitble?
- 9 Answers
- 61305 Views
- TCS, I also Faced
- E-Mail Answers
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
Differentiate between reusable transformation and mapplet.
What is joiner transformation in informatica?
What is a node in Informatica?
What is the difference between informatica 7.0 and 8.0?
What is deployment group?
How do you load alternate records into different tables through mapping flow?
What is the difference between writing a joiner query in ANSI style and THETA style?
How can we use batches?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Write the unconnected lookup syntax and how to return more than one column.
Why do you use Mapping Parameter and mapping variable?
What is the meaning of decode in informatica?
What is a pre-defined event and user-defined event?
How to do unit testing in informatica? How to load data in informatica ?
Which transformation is needed while using the Cobol sources as source definitions?
