Page 1 of 1
Differences b/w fileset & dataset. which is best and Y?
Posted: Fri Sep 14, 2018 11:25 am
by Raa_ONE
What are the major differences between dataset and fileset.
Also, help me with which one is best in what conditions.
Posted: Fri Sep 14, 2018 8:13 pm
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).