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

differences between service based and product based?

0 Answers   Satyam,

which transformation uses cache?

3 Answers   Keane India Ltd,

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

What are the popular informatica products?

0 Answers  

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

what is mapping optimization? wat are the techniques for tat

2 Answers  

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

How can you increase the performance in joiner transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories