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 is informatica powercenter repository?
Which transformation is needed while using the Cobol sources as source definitions?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we create index after completion of load process?
Explian the Process of deployment groups in informatica
What you know about transaction control transformation?
What is workflow? What are the components of workflow manager?
What are active transformations.
What is Data Caches size?
What is the session task and command task?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Global and Local shortcuts. Advantages.
How many transformations can be used in mapplets.
How do you change a non-reusable transformation to reusable transformation?