how lookup is acting as both active and passive ?
how is it possitble?
Answer Posted / jay
There is an option in the properties of Lookup transformation in which we could select "First", "Any" or "Last" which would may give only one row.
So it is Active transformation.
| Is This Answer Correct ? | 11 Yes | 16 No |
Post New Answer View All Answers
What is the surrogate key?
What are the new features of informatica 9.x at the developer level?
Explain in detail about scd type 1 through mapping.
How can we remove the duplicates from flat file source?
How can we update a record in the target table without using update strategy?
explain abt ur project architecture?
Differentiate between sessions and batches?
Mention some types of transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the different types of olap? Give an example?
How to extract the informatica rejected data?
What are the different clients of powercenter?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Under which circumstances, informatica server creates reject files?
What is the function of aggregator transformation?