Differences b/w fileset & dataset. which is best and Y?

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
Raa_ONE
Participant
Posts: 5
Joined: Fri Sep 14, 2018 10:56 am

Differences b/w fileset & dataset. which is best and Y?

Post by Raa_ONE »

What are the major differences between dataset and fileset.

Also, help me with which one is best in what conditions.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is no "best". There is only "the right tool for the job".

Each preserves partitioning and sorted order of data.

Data Sets keep the internal (binary) formats of data. They are intended to be used only with DataStage, and are perfect for staging data between jobs. The operator for both writing and reading Data Sets is copy.

File Sets translate the internal data into (or from) a human-readable format. You have to supply similar Format properties to those you provide for Sequential File stage. They are intended to be able to be read from (and, perhaps, written to) by other applications. The operator for writing a File Set is export and for reading a File Set is import (the same operators as are used for Sequential File).
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