Difference between Sequential file vs hash file in Datastage Server Jobs?

Difference between Sequential file vs hash file in Datastage Server Jobs

Sequential File:

  • It is used to read/write a Flat File  Sequential File
  • The Data will be loaded normally
  • This is not an used for performace wise
  • No limit for storage
  • Single File only create for output
  • Not query possible in Flat file or Sequential File
  • It does not perform for remove duplicates
  • It does not support for lookup operation

Hash File:

  • It is used to read/write a  Hash File
  • Data is loaded based on Hash Alogorithm
  • This is very effictive to store the temporary Data
  • it supports upto 2 GB then over-write
  • Hash file Creates two files (Static file and Dynamic)

1) DATA.30(ACTUAL DATA)

2) OVER.30(NORMAL SPACE)

  • We can query in Hash File
  • It removes the Duplicate Records
  • It supports for lookup operation
Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*