What is the difference between sequential file and Dataset

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
balu124
Participant
Posts: 49
Joined: Wed Jul 25, 2007 9:53 pm

What is the difference between sequential file and Dataset

Post by balu124 »

Hi ,
Can any one tell me the difference bet ween Sequential file and Dataset?
Can we delete the Dataset?Can we copy the Dataset?
RavishankarMS
Participant
Posts: 8
Joined: Tue Oct 23, 2007 5:12 am

Post by RavishankarMS »

I think better you refer Parallel job Developers Guide for detail info.
But to brief ,in DataStage job processing data flows in datasets format & DataSet stage is used to store the data in same raw format which could be viewed through DataStage View facility.

Whereas sequential files are flat files which stores data in readable UNIX format.
Regards,
Ravishankar M S
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Re: What is the difference between sequential file and Datas

Post by priyadarshikunal »

balu124 wrote:Hi ,
Can any one tell me the difference bet ween Sequential file and Dataset?
Can we delete the Dataset?Can we copy the Dataset?

try to hit the search button first before posting a new topic
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

A Data Set is a parallel structure which stores data on all nodes on which processing is occurring. It preserves internal data types, partitioning and sorting. Indeed the operator used to move data between physical and virtual Data Sets is the copy operator.

Sequential files exist in only one place, and must be written to by exactly one process, so do not have any inherent parallelism capability. They usually contain text so must be read by an import operator and written by an export operator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply