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

Which one is better performance wise connected/un-connected
lkp?why?

Question Posted / maheedhar

Answers were Sorted based on User's Feedback



Which one is better performance wise connected/un-connected lkp?why?..

Answer / rayudu

Connected lookup is used to lookup on each and every row
bjut unconnected lookup is used to lookup only when the
condition is true i,e unconnetcec is used only for selectetd
rows so obviously unconnected is faster .


Regards,
rayudu.

Is This Answer Correct ?    18 Yes 3 No

Which one is better performance wise connected/un-connected lkp?why?..

Answer / yamini

Performance wise unconnected look up transformation is better as it returns only one port and doesn't build any dynamic cache. Only static cache is build. It can be used any where in the mapping using LKP expression in another transformation.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

what we require for D.modelling?

1 Answers  

What is enterprise data warehousing?

0 Answers  

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

What are the measure objects?

0 Answers  

Define pmcmd command?

0 Answers  

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

Which development components of informatica have the highest usage?

0 Answers  

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories