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...


Performance wise which is better joiner or look up ?
Give me with example?



Performance wise which is better joiner or look up ? Give me with example?..

Answer / abhinaw prakash

There is no definite answer to this.But if we are using
homogenous data sources its better to use Look up rather
than joiner.
Again Look up can only perform left outer join.So for other
Join we have to use Joiner.

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,


what is degenerated dimension

6 Answers   Cap Gemini,


r u done any partitions in ur project?

0 Answers   TCS,


What is the need of etl tools?

0 Answers  


what is bridge tables in informatica

1 Answers   CTS,


100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


What is tracing level and what are the types of tracing level?

2 Answers   TCS,


What is partioning?how many types of partinings are there

2 Answers   HCL,


What is the use of target designer?

0 Answers  


Do you have to change the reject file b4 using reject loader utility.

1 Answers  


Differentiate between a repository server and a powerhouse?

0 Answers  


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

2 Answers  


Categories