difference between datasetstage and sequential file stage
Moderators: chulett, rschirm, roy
difference between datasetstage and sequential file stage
hi can any one tell me the difference between dataset stage and sequential stage?
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
thank you very muchvmcburney 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.