What is a diff between joiner and lookup transformation
- 16 Answers
- 92858 Views
- CTS, Satyam, TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / sweta kedia
. I) Joiner is active transformation & lookup is passive
transformation.
II) Joiner operates on sources where as lookup operates
source as well
as target.
III)Joiner doesnt support nonequi joins whereas lookup
supports nonequi join
i.e. joiner transformation supports only equality operator
in condition of join where as lookup transformation can
support<=,>=,=,!= in the lookup condition.
IV) Lookup uses dynamic and static cache where as a joiner
doesn’t.
V) Joiner transformation does not match for null values
whereas lookup transformation matches for null values.
VI) Joiner will do left outer,right outer,normal,full outer
types of joins whereas lookup will do only left outer join.
| Is This Answer Correct ? | 34 Yes | 3 No |
Post New Answer View All Answers
what is mean by complex business rule ?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the tasks that source qualifier perform?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the Process to creating lookup transformation in informatica
Explain the difference between mapping parameter and mapping variable?
What differs when we choose the sorted input for aggregator transformation?
Design a mapping to load a target table with the following values from the above source?
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 are the main features of Oracle 8i with context to datawarehouse?
Clarify the utilization of aggregator cache record?
What do you mean by blocking transformation?
What is sequence generator transformation in informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
