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

Hash files is the only way to do lookup .. It is key based
and ensures no duplicates are present on that key. It wont
give an error if you use OCI or DB2 stage as lookup but the
results will be wrong...

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1746


Describe the main features of datastage?

1076


How do you run datastage job from the command line?

1091


Can you filter data in hashed file?

3772


Can you explain engine tier in information server?

1135


Explain how a source file is populated?

1366


How to Remove Duplicate using SQL?

1369


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2375


What are the different types of lookups in datastage?

1054


How will you move hashed file from one location to another location?

2151


how to implement scd2 in datastage 7.5 with lookup stage

5605


Explain the importance of surrogate key in data warehousing?

1190


What are constraints and derivations?

1170


What are the steps required to kill the job in Datastage?

1218


What are the main features of datastage?

1281