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
- 8243 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
What are roles and groups and benefits of using them?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In how many ways we can create ports?
Why filter transformation is an active one?
According to his methodology what all you need before you build a datawarehouse
Explain about Informatica server process that how it works relates to mapping variables?
In informatica workflow manager, how many repositories can be created?
What are the prerequisite tasks to achieve the session partition?
Is it possible to revert a global repository to local one and why?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to use pmcmd utility command?
What is workflow monitor?
What all are steps in up gradation of Informatica server?
What is a filter transformation?
