:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> Data Warehouse >> Data Stage


 Teradata interview questions  Teradata Interview Questions (178)
 Business Objects interview questions  Business Objects Interview Questions (750)
 Cognos interview questions  Cognos Interview Questions (836)
 Informatica interview questions  Informatica Interview Questions (1617)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (562)
 SAS interview questions  SAS Interview Questions (549)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (193)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (214)
what is the exact difference between dataset and fileset in 
 Question Submitted By :: Sow_1
I also faced this Question!!     Rank Answer Posted By  
  Re: what is the exact difference between dataset and fileset in datastage?
# 1
Dataset is same as that of fileset only difference is reject
link and external use.
Is This Answer Correct ?    3 Yes 6 No
  Re: what is the exact difference between dataset and fileset in datastage?
# 2
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 ?    5 Yes 2 No
  Re: what is the exact difference between dataset and fileset in datastage?
# 3
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 ?    0 Yes 0 No
Lokesh Butra
  Re: what is the exact difference between dataset and fileset in datastage?
# 4
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.

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
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

In simple words the data from the DataSet can be read
faster than from FileSet.
Is This Answer Correct ?    8 Yes 1 No
  Re: what is the exact difference between dataset and fileset in datastage?
# 5
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 ?    3 Yes 0 No

Other Data Stage Interview Questions
  Question Asked @ Answers
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.   6
table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?   9
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.   1
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction Reliance 1
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.   4
can any one tell me how to install datastage 8.1 in windows xp with wizard   2
how to cleansing data Cap-Gemini 5
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 HCL 1
How to enter a log in auditing table whenever a job get finished? L&T 1
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....   3
For more Data Stage Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright 2013  All Rights Reserved.   ::