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
- 61608 Views
- TCS, I also Faced
- E-Mail Answers
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
update strategy transformation in informatica
What is the use of target designer?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the advantage of informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the different transaction levels available in transaction control transformation?
What if the source is a flat-file?
what is $$$$?
Differences between version 7.x and 8.x.
How do you use reject loader.
what is SDLC way of code development?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How do you load alternate records into different tables through mapping flow?
Clarify the aggregator change?
To import the flat file definition into the designer where should the flat file be placed?
