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

why we use hash file for lookup?

Answer Posted / hari

Hash partitioning
method is the key
based partition
method... And lookup
wich also compare and
retrieve the data
based on key
column... So by using
hash method wil
increase performance
in lookup...

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Routines and their types?

1114


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4147


What are the main features of datastage?

1216


What is the difference between orabulk and bcp stages?

982


How can we improve the performance in datastage?

1067


What is a ds designer?

1030


What is merge stage?

1237


Give an idea of system variables.

973


client know skid info?

2042


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3613


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3275


What are stage variables and constants?

1102


What are the job parameters?

1170


What all the types of jobs you developed?

1125


Name the different types of Lookups in Datastage?

1219