Answer Posted / kumarapillaietl@gmail.com
in before informatica powercenter 9 version lookup it is works passive tranformation ,after that 9X lookup works both passive and active ,
informatica provide aditional features, at the time of lookup creation (multi match) check bok option is there , when you check multi match its works active.
genraly we can get source table,target tables,flatfiles al lthous thinks and compare hetroginious sources using lookup.
lookup participate each SCD mappig flow.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a node in Informatica?
Define the various join types of joiner transformation?
How does a sorter cache works?
What is joiner change?
Explian the Process of deployment groups in informatica
Plz can any one say me how to get the informatica certification materials and dumps
How do you handle two sessions in Informatica
tell me about your project functionality
What is meant by query override?
What do you mean incremental aggregation?
What are the informatica performance improvement tips
How to do unit testing in informatica? How to load data in informatica ?
What differs when we choose the sorted input for aggregator transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What is a sequence generator transformation?
