Interested to Buy Any Domain ? << Click Here >> for more details...
lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?
- 5 Answers
- 8598 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akash
An active transformation handles data in groups while a
passive transformation handles them row-by-row. Lookup
handles each record one by one. So it is a passive
transformation.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How can one identify whether mapping is correct or not without connecting session?
What is Session and Batches?
What are the uses of etl tools?
What is the difference between a repository server and a powerhouse?
Please let me know how to make Data masking in informatica..
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is rank transform?
How do you change a non-reusable transformation to reusable transformation?
How you prepared reports for OLAP?
How to join three sources using joiner? Explain though mapping flow.
How do you migrate data from one environment to another?
How to differentiate between the active and passive transformations?
How many dimensions are there in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between Active and Passive transformation?
