DSXchange

hi can any one tell me the difference between dataset stage and sequential stage?

The dataset is the fastest way to save data from a parallel job to disk as it maintains the partitioning and metadata of the data. This makes it a good choice for staged data or reference data but they can only be written, read or used by DataStage jobs. Sequential files are plain text files with either delimited or fixed width columns that need to be imported from text to parallel data types and partitioned, so they are slower to read or write but they are a common format for exchanging data with other systems and other products.

This topic was discussed many times in this database and answered by the Gurus of Dsxchange.
Please search before posting. Personally, i learn't many thing by a 'simple' search.

vmcburney wrote:The dataset is the fastest way to save data from a parallel job to disk as it maintains the partitioning and metadata of the data. This makes it a good choice for staged data or reference data but they can only be written, read or used by DataStage jobs. Sequential files are plain text files with either delimited or fixed width columns that need to be imported from text to parallel data types and partitioned, so they are slower to read or write but they are a common format for exchanging data with other systems and other products.

thank you very much