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 sparse lookup?

Answer Posted / naresh

Sparce Lookup : if u use normal lookup it takes the entire
table into memory and perform lookup..coming to sparce
lookup it directly perform the lookup in database level.

one more difference is we can update the data into reference
tables.

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

On which interface you will be working as a developer?

1043


How to RD using transformer?

1424


What are routines in datastage? Enlist various types of routines.

1101


How to perform incremental load in datastage?

1203


What is process model?

1976


Give an idea of system variables.

1036


What are the main differences you have observed between 7.x and 8.x version of datastage?

1089


How can we improve performance of data stage jobs?

1017


Explain usage analysis in datastage?

1163


What is job control?

1112


What are stage variables, derivations and constants?

1226


What is oci?

1301


Difference between server jobs & parallel jobs?

1077


Explain how a source file is populated?

1366


How and where you used hash file?

1174