difference between datasetstage and sequential file stage

bhaggu · Post by **bhaggu** » Wed Apr 18, 2007 9:44 pm

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

vmcburney · Post by **vmcburney** » Wed Apr 18, 2007 11:24 pm

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.

dspxlearn · Post by **dspxlearn** » Thu Apr 19, 2007 12:08 am

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.

bhaggu · Post by **bhaggu** » Thu Apr 19, 2007 8:20 am

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