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
What is a joiner transformation and why it is an active one?
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?
How can we update a record in the target table without using update strategy?
What is meant by query override?
How can you validate all mappings in the repository simultaneously?
Reusable transformation and shortcut differences
Explain the informatica workflow?
What is decode in informatica?
Sequence generator, when you move from develoment to production how will you reset
During the running session, output files are created by informatica server. Enlist few of them.
How do you promote a non-reusable transformation to reusable transformation?
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?
What is rank transform?
what is the hint? how to use it to reduce the query processing in program?
How are the sources and targets definitions imported in informatica designer?