how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / vidyasagar
@Srinivas
after condition satisfies it does'nt reduces rows
say
src_table Lookup_table Result
10 10 10
20 Null
30 Null
number of sources=3 and result also 3 rows hence
Lookup is a passive transformation :)
Regards:
Vidyasagar
| Is This Answer Correct ? | 7 Yes | 12 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
Did u used latest transformations of 8.6.0? for what?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Define the various join types of joiner transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Explain your project of banking domian.
Where is metadata stored?
What is fact table? Explain the different kinds of facts.
How can you differentiate between powercenter and power map?
How to generate sequence numbers without using the sequence generator transformation?
what is unit testing?tell me proceedure
Name at least 5 different types of transformations used in mapping design and state the use of each.?
have u done any performance tuning? how u ll do?
Explain the different kinds of facts.
What is the different lookup cache(s)?