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

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

Answer Posted / sam

Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Slowly changing dimensions, types and where will you use them

1713


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10681


How can we update a record in the target table without using update strategy?

1145


What is meant by lookup transformation? Explain the types of lookup transformation?

947


What is a stored procedure transformation?

1053


How many numbers of sessions can one group in batches?

1064


Different circumstance which drives informatica server to expel records?

983


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

2119


What is an active transformation?

1106


Define mapplet?

1008


How to generate sequence numbers without using the sequence generator transformation?

1206


What is the function of look up transformation?

1123


What are the data movement modes in informatica?

1152


generate date / time dimension in informatica

1125


What is a transaction control transformation?

1206