Fileset vs Dataset

[dstest]

I would like to know which stage is faster compare with fileset and dataset.Becuase both operates in parallel mode and the problem with dataset is it is using more space when compare with sequential file with the same number of records.

Thanks

[ray.wurlod]

Data Set is faster because no translation (export/import) is required. Both a File Set and a Data Set will use more space than a sequential file because, among other things, they include information related to the partitioning and sorted order of the rows they contain. Storage of unbounded VarChar data types is also done differently.