sequential file cf. data set

djoni · Post by **djoni** » Thu May 25, 2006 12:02 pm

Assume for my specific case I can use either one, what is the main advantage of using data set over sequential file?
djoni

DSguru2B · Post by **DSguru2B** » Thu May 25, 2006 12:39 pm

I found a very interesting post. Which happens to be a response to your quest. Please, by all means, click on me
In particular. Read ArndW's reply. He has described the difference in a very mastery way (if that is a word

)

ray.wurlod · Post by **ray.wurlod** » Thu May 25, 2006 3:44 pm

In a word, parallelism

ashwin141 · Post by **ashwin141** » Fri May 26, 2006 6:43 am

In sequential file you can read and write the data only sequentially, whereas if you are using a dataset you can read and write the data, parallely or sequentially. Default mode being Parallel. Datasets don't store the data like a sequential file at the specified physical location.
They are normally recommended as intermediate files throughout your processing.

I hope it helps.

Regards
Ashwin

kumar_s · Post by **kumar_s** » Fri May 26, 2006 9:20 am

Dataset is stored in the native data type of Datastage. And hence it is more easily and effeciently read/written by datastage (and only by datastage.)