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



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

Answer / 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

More Informatica Interview Questions

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,


What is the difference between view and materialised view?

4 Answers  


In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1 Answers   HP,


how to duplicates from expression transformation without using sorter before that

1 Answers  


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


What is data transformation manager process?

0 Answers  


Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  


How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  


how to join two flat files in informatica?

3 Answers   Wipro,


Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


Categories