how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / vidyasagar
Dude Jay,
its a passive transformation
in yo case eventhough you are selecting first last or any
it will select the selected column and null for the rest of
the rows so the number of rows remains same , hence its the
passive transformation.
one more thing you can by-pass the lookup so only a passive
txn can be by-passed.
if anyone have any queries lemme know :)
Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
Can anyone tell me the new features in Informatica 9 Version?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What do you mean incremental aggregation?
What are the differences between source qualifier and joiner transformation?
What is meant by LDAP users?
Explain sessions and how many types of sessions are there?
What are data-driven sessions?
What is a mapplet/worklet in informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is lookup change?
What is the status code in stored procedure transformation?
What are the uses of etl tools?
How to do the error handling of if ur source is flatfiles?
What does update strategy mean, and what are the different option of it?
Is it possible to define a single node as a Gateway node as well as worker node?