How the hash file is doing lookup in serverjobs?How is it comparing the key values? - Hashed File is used for two purpose: 1. Remove Duplicate Records 2. Then Used for reference lookups.The hashed file contains 3 parts: Each record having Hashed Key, Key Header and Data portion.By using hashed algorith and the key valued the lookup is faster. - DataStage Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATA WAREHOUSING

DATASTAGE

DETAILS

Question: How the hash file is doing lookup in serverjobs?How is it comparing the key values?

Answer: Hashed File is used for two purpose: 1. Remove Duplicate Records 2. Then Used for reference lookups.The hashed file contains 3 parts: Each record having Hashed Key, Key Header and Data portion.By using hashed algorith and the key valued the lookup is faster.

Category	DataStage Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8133 users
Added on	7/26/2011
Views	69915
Rate it!

Question: How the hash file is doing lookup in serverjobs?How is it comparing the key values?

Answer:

Hashed File is used for two purpose: 1. Remove Duplicate Records 2. Then Used for reference lookups.The hashed file contains 3 parts: Each record having Hashed Key, Key Header and Data portion.By using hashed algorith and the key valued the lookup is faster. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is data set? and what is file set?	View Answer
	What are the enhancements made in datastage 7.5 compare with 7.0	View Answer
	If I add a new environment variable in Windows, how can I access it in DataStage?	View Answer
	1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance of DataStage? 4.what are the Job parameters? 5.what is the difference between routine and transform and function? 6.What are all the third party tools used in DataStage? 7.How can we implement Lookup in DataStage Server jobs? 8.How can we implement Slowly Changing Dimensions in DataStage?. 9.How can we join one Oracle source and Sequential file?. 10.What is iconv and oconv functions? 11.Difference between Hashfile and Sequential File? 12. Maximum how many characters we can give for a Job name in DataStage?	View Answer
	It is possible to call one job in another job in server jobs?	View Answer
	What is hashing algorithm and explain breafly how it works?	View Answer
	If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?	View Answer
	How to implement type2 slowly changing dimensions in data stage?explain with example?	View Answer
	Is it possible to move the data from oracle ware house to SAP Warehouse using with DATASTAGE Tool.	View Answer
	How much would be the size of the database in DataStage ? What is the difference between Inprocess and Interprocess ?	View Answer
	How I can convert Server Jobs into Parallel Jobs?	View Answer
	What is the max capacity of Hash file in DataStage?	View Answer
	How to use rank&updatestratergy in datastage	View Answer
	What is the difference between drs and odbc stage	View Answer
	what is meaning of file extender in data stage server jobs. can we run the data stage job from one job to another job that file data where it is stored and what is the file extender in ds jobs.	View Answer
	How does DataStage handle the user security?	View Answer
	What are the Steps involved in development of a job in DataStage?	View Answer
	Briefly describe the various client components?	View Answer
	What is a project? Specify its various components?	View Answer
	* What are constraints and derivation? * Explain the process of taking backup in DataStage? *What are the different types of lookups available in DataStage?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All DataStage Interview Questions & Answers - Exam Mode / Learning Mode