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

what is mean by complex business rule ?

2218


What is a pre-defined event and user-defined event?

1079


Explain sessions. Explain how batches are used to combine executions?

1078


What are junk dimensions?

1111


Briefly define reusable transformation?

1180


how to create user defined function (udf) in informatica

1349


How an expression transformation differs from aggregator transformation?

1087


What is the sql query overwrite in source qualifier in informatica

1140


What are the different ways to implement parallel processing in informatica?

1479


What is rank transformation?

1035


Explain how to import oracle sequence into informatica?

1071


What is the Process to creating lookup transformation in informatica

1090


Global and Local shortcuts. Advantages.

2088


What are the differences between source qualifier and joiner transformation?

1135


What is deployment group?

1296