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

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

COM components can be used in Informatica

0 Answers  

How does the aggregator transformation handle null values?

0 Answers  

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

what is the gap analysis?

1 Answers  

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

Which kind of index is preferred in DWH?

3 Answers  

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

How will you update the row without using update statergy?

10 Answers   CTS,

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories