Dataset stage and sequential file stage

What is the difference between dataset stage and sequential file stage? even one more to be added here, What is the difference between dataset stage and fileset stage?

Questions by taruna.arya

Showing Answers 1 - 11 of 11 Answers


  • Oct 23rd, 2014

Main Difference Between Dataset stage And Sequential file Stage is Null Value is Not allowed in Sequential File Stage Also Max File Size For Sequential File is 2 GB. Where as In Dataset Stage There Is No Limit of File Size.(Note : Can Use Maximum size which is available Size in disk)


  • Dec 22nd, 2014

main difference is sequential file doesn't support parallelism concept.where in datasets by default support parallelism concept.

  Was this answer useful?  Yes

ravikumar a v

  • Jan 18th, 2015

Dataset stage is used for reference in put link in other jobs design and where as sequential file stage is not possible.

  Was this answer useful?  Yes


  • Feb 23rd, 2015

Dataset: It stores data in the ASCII format so it takes less time to read data for datastage

IT can accommodate large amount of data

Sequential file stage: It contains data in the readable format, it can accommodate only 2GB data

It doesn't support null value, also we can capture the reject data in seq file stage.

  Was this answer useful?  Yes


  • May 25th, 2015

the extension of dataset is .ds and it never used extract data from client location ,it is used as a intermediate stage b/w two tables
sequential file it support all formats like .xls, csv ,txt etc,and it used to extract data from flat files from client location

  Was this answer useful?  Yes

sudha rani

  • Jun 25th, 2015

In sequential stage we can run UNIX commands, but in data set we can not run UNIX commands

In sequential file we can run remove and move commands, but in data set we can not run remove and move commands

In data set file we can read only .ds files and it never extracts the data from client location, but in sequential file we can any run any type of format for example .xls .txt .csv. it extracts the data from flat files from client location

  Was this answer useful?  Yes


  • Feb 9th, 2016

DataSet Stage : Dataset stage can only use as intermediate file stage, It cant be a source or target. (Means you can use Dataset file stage as a source but that source Dataset file stage should be a target file of other job)
It can accept large amount of data.
It can accept/support as single input/output file.
Sequential file stage : It can be use as source or target.
It can accept upto 2GB of data.
It can accept/support multiple source files/target files.

  Was this answer useful?  Yes


  • Feb 18th, 2016

In sequential file data flows sequentially.
In dataset data flows parallely.
In sequential file data processing is slow.
In dataset data processing is fast.
We can capture the rejected data in sequential file.
We cannot capture the rejected data in data set.
In sequential file data is in readable format.
In data set data is not in readable format in UNIX.
We can delete sequential file by using rm command.
We can delete data set by using orchadmin command.
In sequential file at the compilation time it will convert to native from ASCII.
In data set conversion is not required.

  Was this answer useful?  Yes


  • May 23rd, 2017

Dataset is orchestrate framework. Control file is associated with each dataset. It is faster to read data.

File Set support I/p, O/p and reject link. Executes in parallel mode.

  Was this answer useful?  Yes


  • Jul 14th, 2017

Sequential file also supports reference link.

  Was this answer useful?  Yes


  • Jul 24th, 2017

1) Sequential file stage we can use UNIX commands and in dataset stage we cant use UNIX commands.
2) Sequential file stage filename save as .txt and dataset - .ds

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions