deepakatsit

 Profile Answers by deepakatsit 

• 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)

karthik

• Dec 22nd, 2014

 

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

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.

kritika

• 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.

jallu

• 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

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

NirmalkSahoo

• 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.

pragnya

• 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.

Himapriya

• 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.

Anshula

• Jul 14th, 2017

 

Sequential file also supports reference link.

ravikumar

• 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

Sourabh Kulkarni

• Jan 22nd, 2023

 

Deepak!, how to load a sequential file stage having data more than 2 Gb?