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?
Answer Posted / sarthak
Your Question is wrong......
this data belongs to Source table or look up table..
Multiple match principle comes in lookup table(not in source
table)..
if no. of rows in source table that connected to lookup t/f
is 3,then the output of lookup t/f is 3 rows...
it will not decrease
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can we use batches?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the command used to run a batch?
Differentiate between sessions and batches?
What is incremental aggregation?
Explain Dataware house architecture .how data flow from intial to end?
What is decode in informatica?
In informatics server which files are created during the session rums?
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,
What is Index Caches size?
What are junk dimensions?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Tell me about MD5 functions in informatica
Where do we use mapping variables in informatica?
How to load the data from people soft hrm to people soft erm using informatica?