Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / krishna213666

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

Can we override a native sql query within informatica?

0 Answers  

what are types of dimentions?

3 Answers  

what is the difference between stop and abort

2 Answers  

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

who to split dimentions into sub dimention

3 Answers   Wipro,

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

What happens if we dont select data driven option?

2 Answers   Zensar,

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

can you please explain me pre session and post session options?

3 Answers   BTBP,

For more Informatica Interview Questions Click Here
Categories