Page 1 of 1

which suits large volume of data dataset or fileset

Posted: Wed Jul 21, 2004 5:26 am
by kruthika
Hi,

In a parallel job, Which suits large volume of data better...Fileset or Dataset..

Thanks

Posted: Tue Aug 24, 2004 4:25 pm
by vbeeram
Hi,

Datset


Thanks
Thiru

Posted: Tue Aug 24, 2004 9:34 pm
by mandyli
Hi kruthika ,

If you are using more then 4g.b data go for dataset b'cus file set will not workin in PX mode.

Posted: Tue Aug 24, 2004 11:40 pm
by ray.wurlod
Do you have some proof for this claim, Mandy?

Even if you are on an operating system that only supports 2GB files, a fileset can contain many physical files, so there should not be any limit to the size of a fileset.

Chapter 6 of the Parallel Job Developer's Guide provides all the extra information you need to know.

The main difference between dataset and fileset, it seems to me, is the fact that a file set also includes information about how the data are formatted.