Difference between DataSet and FileSet

mujeebur · Post by **mujeebur** » Wed Mar 09, 2005 10:48 am

Hi,

What is the basic difference between DataSet and FileSet ? What are best scenarios those can be implemented distinguishly ?

T42 · Post by **T42** » Wed Mar 09, 2005 5:58 pm

On your parjdev.pdf document, read chapter 4 ("Data Set Stage") and Chapter 6 ("File Set Stage").

The PDF is provided with every client installation of DataStage, unless it was turned off.

Happy reading.

richdhan · Post by **richdhan** » Thu Mar 10, 2005 1:25 am

Hi,

Look into these links it will give you some information.

viewtopic.php?t=91381
viewtopic.php?t=91509

Develop a test job using row generator to load data into a dataset and a fileset and try to work on them. You will get more info.

Just think of fileset as a bunch of exported ASCII files used to overcome the limitation of 2GB. Dataset also can be used to overcome the limitation of 2GB but is used to store data in persistent form (e.g NULL representation). A Dataset is cryptic broken and can only be understood by Datastage.

HTH
Rich