GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 329 of 380    Print  
What is the difference between Squential Stage & Dataset Stage. When do u use them.

  
Total Answers and Comments: 3 Last Update: January 25, 2008     Asked by: rangagopi 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
September 27, 2007 03:15:56   #1  
Mangalasamy subbiah        

RE: What is the difference between Squential Stage & D...
Sequential stage is use for format of squential file and Dataset is use for any type of format file (random) 
 
Is this answer useful? Yes | No
January 18, 2008 00:55:30   #2  
vijaykumar_ads Member Since: January 2008   Contribution: 1    

RE: What is the difference between Squential Stage & Dataset Stage. When do u use them.

Parallel jobs use data sets to manage data within a job. You can think of each link in a job as carrying a data set. The Data Set stage allows you to store data being operated on in a persistent form, which can then be used by other WebSphere DataStage jobs. Data sets are operating system files, each referred to by a control file, which by convention has the suffix .ds. Using data sets wisely can be key to good performance in a set of linked jobs. You can also manage data sets independently of a job using the Data Set Management utility, available from the WebSphere DataStage Designer or Director In datset dat is stored in some encrypted format ie., we can view the data through view data facility available in datastage but it cant be viewed in Linux or back end system. In sequential file data can be viewed any where. Extraction of data from the datset is much more faster than the sequential file.


 
Is this answer useful? Yes | No
January 25, 2008 04:39:45   #3  
manoharkolukula Member Since: January 2008   Contribution: 32    

RE: What is the difference between Squential Stage & Dataset Stage. When do u use them.
Sequential file can used as a target file but Dataset can't be used as final target, it can be used as temperary target.

Dataset can be used as a hashfile(just like in server hashfile), it improves the performence.

I think Dataset has no limit and seq file has a size limit.

Seq file doesnot show the null values means it never accepts the null, we to pass some value, but it is not in dataset.

performence is very good in dataset when compared to seq file bcoz of ll'lalism.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape