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
- 8436 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 the tasks that source qualifier perform?
Explain in detail about scd type 1 through mapping.
What are the various types of transformation?
How to Create a folder using pmrep command?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the new features of informatica 9.x in developer level?
Design a mapping to load a target table with the following values from the above source?
What is an active transformation?
without table how to come first record only in oracle?
What is the command used to run a batch?
In warehouses how many schemas are there?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How can repository reports be accessed without sql or other transformations?
How can a transformation be made reusable?
Where is metadata stored?
