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
- 8433 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / varun4db
In this case for first row with 101 id it will give random(
either first or last or any or error). And again for second
row 101 it will return any random( either first or last or
any or error).
So the count of out put row is equal to the input row. so it
is passive only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
What is the need for an etl tool?
What is workflow manager?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Explain the different kinds of facts.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How many ways are there to do 'remove duplicate records in informatica'?
Define pmcmd command?
What is the session task and command task?
How can we use batches?
Which transformation is needed while using the Cobol sources as source definitions?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are mapplets?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Where is metadata stored?
