GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 199 of 390    Print  
What is the difference between sequential file and a dataset? When to use the copy stage?

  
Total Answers and Comments: 5 Last Update: June 03, 2008     Asked by: vsarita80 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: shobhitvkgupta
 
DataSet supports parallelism but sequential file doesn't

Above answer was rated as good by the following members:
K.Sivaram
June 29, 2006 10:48:18   #1  
shiva        

RE: What is the difference between sequential file and...
Sequential file stores small amount of the data with any extension .txt where as DataSet stores Huge amount of the data and opens the file only with an extension .ds.
 
Is this answer useful? Yes | No
June 29, 2006 10:50:15   #2  
shiva        

RE: What is the difference between sequential file and...
Sequentiial Stage stores small amount of the data with any extension in order to acces the file where as DataSet is used to store Huge amount of the data and it opens only with an extension (.ds ) .The Copy stage copies a single input data set to a number of output datasets. Each record of the input data set is copied to every output data set.Records can be copied without modification or you can drop or change theorder of columns.
 
Is this answer useful? Yes | No
October 27, 2006 03:07:09   #3  
Ravi        

RE: What is the difference between sequential file and...

hi

Main difference b/w sequential file and dataset is : Sequential stores small amount of data and stores normally.But dataset load the data like ansi format.


 
Is this answer useful? Yes | No
December 12, 2006 14:50:56   #4  
kirupakaran        

RE: What is the difference between sequential file and...

hi all

sequential file:

it act as a source & permanent storage for target.it 's extend is .txt.

dataset:

it act as a temporary storage stage mainly it used before the target stage

while using this stage the ip datas r partited &convert into internal dataset format.then it is easy to load the data in target stage .

copy:

it act as a placeholder.it has a single ip &many o/p .

if u want 2 add a new stage in ur job at that time it is very easy otherwise u have to modify that whole job.


 
Is this answer useful? Yes | No
June 03, 2008 06:40:36   #5  
shobhitvkgupta Member Since: June 2008   Contribution: 1    

RE: What is the difference between sequential file and a dataset? When to use the copy stage?
DataSet supports parallelism but sequential file doesn't
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape