Interested to Buy Any Domain ? << Click Here >> for more details...
what is the exact difference between dataset and fileset in
datastage?
- 5 Answers
- 45586 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
DataSet:
1. The fundamental concept of the Orchestrate
framework is the Data Set. Data Sets are the inputs and
outputs of Orchestrate operators.
2. As a concept a Data Set is like a database table,
in so far as it is a collection of identically-defined
rows. It is the only structure on which Orchestrate
operators operate. Each operator( i.e., stage) accepts
input from one Data Set and sends its output to another
Data Set.
3. A Data Set exists on all the processing nodes
defined for the job that is currently processing it. That
subset of rows in a Data Set that are located on a single
processing node is referred to as a "partition" of the Data
Set. Technically, a partition is a subset of the rows in a
Data Set (or File Set) earmarked for processing on the same
processing node.
4. A control file is associated with each data set.
The control file contains the record schema that defines
the row structure (effectively its column definitions).
5. Within a Data Set data are stored in internal, or
machine-compatible format.
FileSet:
1. It allows you to read data from or write data to a
file set.
2. The stage can have a single input link, a single
output link and a single reject link.
3. It only executes in parallel mode.
4. The data files and the file that lists them are
called a file set. This capability is useful because some
operating systems impose a 2 GB limit on the size of a file
and you need to distribute files among nodes to prevent
overruns.
5. Only advantage of using fileset over a sequential
file is "it preserves partitioning scheme"
A dataset is a file/stage where the data can be read
directly by the DataStage, whereas a file set needs to be
converted into DataStage readable format (which happens
internally).
In simple words the data from the DataSet can be read
faster than from FileSet.
| Is This Answer Correct ? | 21 Yes | 4 No |
1) dataset in native format so it can view the data only internally(datastage) where as fileset is in binary format so data can be view in any where which is convert from binary to human understandable language.
2) dataset dont support reject link where as fileset support reject link.
3) dataset is copy operator fileset is import and export operator.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / kavi
In DataSet, data is stored in Binary format.
In fileSet, data is stored in the form of text.
That's it...
| Is This Answer Correct ? | 10 Yes | 12 No |
Answer / lokesh butra
Dataset operate the file local server and also its support
upto 2 GB Data
File set operates the file local and remote servers and
also its support unlimited Data
| Is This Answer Correct ? | 2 Yes | 7 No |
Answer / prakash
Dataset is same as that of fileset only difference is reject
link and external use.
| Is This Answer Correct ? | 7 Yes | 13 No |
Give example for FACTLESS FACT TABLE in real-time scenario.
On which interface you will be working as a developer?
What is the purpose of pivot stage?
What are stage variables, derivations and constants?
how to implement scd2 in datastage 7.5 with lookup stage
WHAT are unix quentios in datastage
What is the difference between server job and parallel jobs?
What are the functionalities of link partitioner and link collector?
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
What are the components of ascential data stage?
How to create environments and call them? What is the use defined variables?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
Teradata 
