DSXchange

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

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 )

In a word, parallelism

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

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.)