DataStage - Difference between Hashfile and Sequential File?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 77 of 390

Difference between Hashfile and Sequential File?

Total Answers and Comments: 3

Last Update: February 12, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 29, 2005 13:07:29

malneedi

Member Since: September 2005 Contribution: 7

RE: Difference between Hashfile and Sequential File?

Hash file stores the data based on hash algorithm and on a key value. A sequential file is just a file with no key column. Hash file used as a reference for look up. Sequential file cannot

Is this answer useful? Yes | No

August 30, 2007 04:39:13

Sanj333

RE: Difference between Hashfile and Sequential File?

Hash file can be stored in DS memory (Buffer) but Sequential file cannot be.. duplicates will be removed in hashfile i.e No duplicates in Hashfile.

Is this answer useful? Yes | No

February 12, 2008 04:55:30

manoharkolukula

Member Since: January 2008 Contribution: 32

RE: Difference between Hashfile and Sequential File?

1. Hashfile can be used as lookup but not the seq file.

2. Hashfile works based on Hashed algorithm.

3. The performence is more in Hashfile when it is used as a ref link(for lkp)

4. we can eliminate duplicates by selecting key value in server jobs.

5. Must and should we have to mention one key in Hashfile.

6. There is a limit of 2GB in Seq file.

.........................

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank