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 differences between oltp and olap?
Is there any way to read the ms excel datas directly into informatica?
Quickly characterize reusable change?
What is pmcmd command?
What are the different clients of powercenter?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How can one identify whether mapping is correct or not without connecting session?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How we can create indexes after completing the loan process?
Differentiate between sessions and batches?
Informatica settings are available in which file?
What is repository manager?
Design a mapping to load a target table with the following values from the above source?
What is the difference between a repository server and a powerhouse?
what is the size of u r source(like file or table)?