how lookup is acting as both active and passive ?
how is it possitble?

Answer Posted / nsiddardh

Both connected ans unconnected look-up transformations are
passive.because the input rows supplied to the look-up are
equal to output rows.so we call look-up transformation is
passive.

Is This Answer Correct ?    17 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a joiner transformation and why it is an active one?

570


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1452


How can we update a record in the target table without using update strategy?

646


What is meant by query override?

630


How can you validate all mappings in the repository simultaneously?

750






Reusable transformation and shortcut differences

1366


Explain the informatica workflow?

580


What is decode in informatica?

647


Sequence generator, when you move from develoment to production how will you reset

1396


During the running session, output files are created by informatica server. Enlist few of them.

535


How do you promote a non-reusable transformation to reusable transformation?

656


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1024


What is rank transform?

593


what is the hint? how to use it to reduce the query processing in program?

6271


How are the sources and targets definitions imported in informatica designer?

666