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 / kannan
Simple logic here,
1) SQ passes the records one by one(logical field values
eg . customer id) to lkp up t\f.
2) Then, with this logicl field values , it looks into the
database( source \target db,provided cache is disabled in
properties), fetched the records(only look up enabled
columns) and passed to the down transformation
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What do you mean by filter transformation?
What do you mean by worklet?
Which transformation is needed while using the Cobol sources as source definitions?
Explain dynamic target flat file name generation in informatica
Why update strategy and union transformations are active? Explain with examples.
Is it possible to create multiple domains on a single Informatica server?
what is $$$$?
What do think which one is the better joiner or look up?
What's the layout of parameter file (what does a parameter file contain?)?
How to join three sources using joiner?
Different qualification between a related rotate toward the sky and isolates look upward?
What is repository manager?
Can we get 1st record through Informatica(without sequence number).
What are the different types of transformation available in informatica.