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

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

Question Posted / guest

Answers were Sorted based on User's Feedback



performance wise which one is better in joiner and lookup transformation?why?explain clearly?..

Answer / soujanya

before cache joiner after cache lookup

Is This Answer Correct ?    4 Yes 0 No

performance wise which one is better in joiner and lookup transformation?why?explain clearly?..

Answer / krishna

joiner is best because we will make less number of records or dublicate records as master. integration servic create cahce for master table. becaue of that cahce size is small and secarching oricess become easy. in case of lookup its should scane om botom to end it will take more time.

Is This Answer Correct ?    0 Yes 0 No

performance wise which one is better in joiner and lookup transformation?why?explain clearly?..

Answer / basha

based on the situation if we need to cache concept we will
use lkp tr ,we doesnot need to caches we use joiner tr
performence wise joiner is better

Is This Answer Correct ?    1 Yes 5 No

performance wise which one is better in joiner and lookup transformation?why?explain clearly?..

Answer / rampriya

Joiner is faster than lookup. Joiner will fetch the data
only once form the database, but the lookup will fetch the
data for each record from the database. So performance wise
joiner is better than lookup.

Is This Answer Correct ?    4 Yes 13 No

Post New Answer

More Informatica Interview Questions

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 do you understand by SOA of Informatica?

0 Answers  

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

explain abt joiner t/r?

1 Answers   IBM,

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

1 Answers   Deloitte,

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

How many transformations can be used in mapplets.

0 Answers  

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

what type of transformation is not supported by mapplets?

4 Answers   CTS,

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories