DSXchange

Hi,
If any can give the information about the difference between Fileset, Sequencial File, Lookup Fileset. Its help for me to understand which one need to use suitably in my project Either FileSet or Sequencial File

Dataset - Written in Datastage internal format and is very efficient (Not readable)
Fileset - not as efficient as a Dataset but it's readable (I use it for archiving)

That leaves the Lookup Fileset

Lookup Fileset: Data is stored in Datastage internal format. But, the main advantage of this stage is that it builds an index on the key column when it stores the data. So, you can use this in scenarios where you may want to use some reference data which would be used in many jobs for lookup.

You would get a whole lot of information from the documentation and by searching DSXchange.

Fileset is partitioned and readable by external applications .
Lookup fileset is also partitioned , But I think it can not be read by external applications ( Correct me If I am wrong)