how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / surendra kumar
Hi,
Lookup is both "Active" as well as "Passive"
Till informatica 8 it was only passive because one of its property "Lookup Policy on Multiple Match" has options of:
i)any values
ii)first values
iii)last values
iv)report error
So for each input record it will produce one output record either any corresponding matching value or Null. But number of Input row is equal to number of output row.
But from Informatica 9 onwards there is one addition in the option of "Lookup Policy on Multiple Match" is:
"Use All Values"
using this property one input row can give multiple output rows i.e number of input rows is not equal to number of output rows.
Thanks & Regards
Surendra Kumar
Is This Answer Correct ? | 39 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x in developer level?
What is the difference between informatica 7.0 and 8.0?
What is option by which we can run all the sessions in a batch simultaneously?
What is Cognos script editor?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
To import the flat file definition into the designer where should the flat file be placed?
tell me about your project functionality
What is joiner transformation?
What are the different transaction levels available in transaction control transformation?
Mention some types of transformation?
Is there any target staging area in informatica not staging area
What is aggregate cache in aggregator transformation?
Global and Local shortcuts. Advantages.
Why sorter is an active transformation?