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 intricate mapping?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How does the aggregator transformation handle null values?
How do you load first and last records into target table?
Explain what are the different types of transformation available in informatica.
Difference between Data and Index Caches?
How can we store previous session logs?
What is a pre-defined event and user-defined event?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
wf dont have integration severances how you can run?
How many number of sessions can one group in batches?
whats the logic to load the lower level of granularity of data to fact table.
What is the need of an ETL tool?
State the differences between sql override and lookup override?
What are 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?