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
- 60837 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
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How does the aggregator transformation handle null values?
Explain your project of banking domian.
Repository user profiles
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Please let me know how to make encryption and decryption with example?
Explain the code page compatibility?
Why do we need informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain the mapping variable usage example in informatica
What do mean by local and global repository?
What is a connected transformation?
What are the components of the workflow manager?
