Hi Experts,

Performance Wise Which transformation is better in LOOKUP
AND JOINER TRansformations? Why? Can anybody please explain
it ?
Please help me out from this Question.

Thanks In Advance.

Answers were Sorted based on User's Feedback



Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformation..

Answer / sukanta

Look up will better perform because the cache is initially
created when the first record will reach at Look up
tarnsformation and the further records are work upon the
cached records.Look up will perfrom left outer Join
only.Other Joins can't be posible.You can check the records
are either exists in the lookup table or not.

Jioner will be slower than look up but sorted port
Join,well choosing of Master and detail configuration will
give better performance for Joiner.

Is This Answer Correct ?    7 Yes 3 No

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformation..

Answer / raj

the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.

Is This Answer Correct ?    5 Yes 10 No

Post New Answer

More Informatica Interview Questions

Describe an informatica powercenter?

0 Answers  


What is the Difference between sorter and aggregator?

2 Answers  


Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,


How to elaborate tracing level?

0 Answers  


I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,






What is the use of an aggregator cache file?

0 Answers  


What is A complex mapping?

3 Answers   TCS,


Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  


How will u find weather dimension table is big in size of a fact table?

1 Answers  


what is the difference between static and dynamic

4 Answers   TCS, Wipro,


split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,


What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,


Categories