ALLInterview.com :: 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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Stage
 
 


  

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
what is the exact difference between dataset and fileset in 
datastage?
 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?
Answer
# 1		 Dataset is same as that of fileset only difference is reject
link and external use. 
Is This Answer Correct ?    3 Yes 5 No
Prakash
 
  Re: what is the exact difference between dataset and fileset in datastage?
Answer
# 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 ?    3 Yes 0 No
Kavi
 
 
 
  Re: what is the exact difference between dataset and fileset in datastage?
Answer
# 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?
Answer
# 4		 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 ?    3 Yes 1 No
Subhash
 

 
 
 
Other Data Stage Interview Questions
 
  Question Asked @ Answers
 
ename like ibm,tcs,hcl need display those records only how?  2
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage? Semantic-Space6
Pls tell me what is troubleshooting in datastage view?  1
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node? TCS3
I have a few records all are same structures data, I want to store data in multiple targets how? Polaris2
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.  4
can a fact table contains textual information HCL4
what is mapping lookup  1
I have a few records just I want to store each records tow times in target how? Polaris2
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer  2
can any one tell me how to install datastage 8.1 in windows xp with wizard  2
how many datamarts we will use in real time project and when will use the datamart?pls send the replay early Tech-Mahindra1
 
For more Data Stage Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com