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
- 6857 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
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Differentiate between sessions and batches?
Which development components of informatica have the highest usage?
pmscmd startworkflow -sv
Differentiate between source qualifier and filter transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
explain abt ur project architecture?
Explain the different lookup methods used in informatica?
How can you differentiate between powercenter and power map?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Define sessions in informatica etl?
Define pmcmd command?
What are data-driven sessions?
How can informatica be used for an organization?
