Hi,
What is the basic difference between DataSet and FileSet ? What are best scenarios those can be implemented distinguishly ?
Difference between DataSet and FileSet
Moderators: chulett, rschirm, roy
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
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