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 is the use of source qualifier?
Where do we use mapping variables in informatica?
How might you approve all mappings in the archive all the while?
Is there any way to read the ms excel datas directly into informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is sorter transformation?
Differentiate between Load Manager and DTM?
How do you set a varible in incremental aggregation
what is the Default Source Option For Update Strategy Transformation?
How to generate sequence numbers without using the sequence generator transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Quickly characterize reusable change?
Why do we need informatica?
How to load a Dimension ? and how to load a fact table?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?