Mangalasamy subbiah

• Sep 27th, 2007

 

Sequential stage is use for format of squential file and Dataset is use for any type of format file (random) 

vijaykumar_ads

 Profile Answers by vijaykumar_ads 

• Jan 18th, 2008

 

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.

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

 

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.