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

what is the diff b/w cached and unchaed look ups

Answer Posted / sujana

if v cache the lukup..IS queries the cache for each row dat
eneters

if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1709


Define Pmrep command?

1110


what is $$$$?

2202


How can you generate reports in informatica?

1081


What is informatica powercenter repository?

1256


Does an informatica transformation support only aggregate expressions?

1086


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141


What are active and passive transformations?

1129


What is dimensional table?

1131


How to elaborate tracing level?

1217


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1097


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2510


Define mapplet?

1058


Differentiate between sessions and batches?

1067


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1340