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


Please Help Members By Posting Answers For Below Questions

What is the use of source qualifier?

662


Where do we use mapping variables in informatica?

609


How might you approve all mappings in the archive all the while?

596


Is there any way to read the ms excel datas directly into informatica?

545


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)

1073






What is sorter transformation?

576


Differentiate between Load Manager and DTM?

1656


How do you set a varible in incremental aggregation

1438


what is the Default Source Option For Update Strategy Transformation?

751


How to generate sequence numbers without using the sequence generator transformation?

637


Which means the first record should come as last record and last record should come as first record and load into the target file?

606


Quickly characterize reusable change?

684


Why do we need informatica?

552


How to load a Dimension ? and how to load a fact table?

948


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?

546