Page 1 of 1
Difference between DataSet and FileSet
Posted: Wed Mar 09, 2005 10:48 am
by mujeebur
Hi,
What is the basic difference between DataSet and FileSet ? What are best scenarios those can be implemented distinguishly ?
Posted: Wed Mar 09, 2005 5:58 pm
by T42
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.
Posted: Thu Mar 10, 2005 1:25 am
by richdhan
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