difference between Fileset, Sequencial File, Lookup Fileset

deesh · Post by **deesh** » Thu May 22, 2008 8:23 am

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

Azzuri · Post by **Azzuri** » Thu May 22, 2008 8:47 am

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)

Minhajuddin · Post by **Minhajuddin** » Thu May 22, 2008 10:42 am

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.

vyyuri · Post by **vyyuri** » Fri Jun 06, 2008 9:45 am

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)