Interested to Buy Any Domain ? << Click Here >> for more details...
how lookup is acting as both active and passive ?
how is it possitble?
- 9 Answers
- 61601 Views
- TCS, I also Faced
- E-Mail Answers
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
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
explain about unit testing? in real time?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Define mapping and session?
What is transformation?
Explain the types of lookup transformation?
How to Create a folder using pmrep command?
Is there any way to read the ms excel datas directly into informatica?
What is a transaction control transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is source qualifier transformation in informatica?
How to start a workflow using pmcmd command?
What are the modules in Power Center
What are the different types of transformation available in informatica.
Quickly characterize reusable change?
