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
- 6861 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
Which means the first record should come as last record and last record should come as first record and load into the target file?
How we can create indexes after completing the load process?
To import the flat file definition into the designer where should the flat file be placed?
What does refresh system mean, and what are its distinctive choice?
What is union transformation?
Which transformation should we use to normalise the COBOL and relational sources?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can one identify whether mapping is correct or not without connecting session?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How are the sources and targets definitions imported in informatica designer?
How will the document be delivered to me?
What are the main issues while working with flat files as source and as targets ?
What is a pre-defined event and user-defined event?
