Why we need datasets ratherthan sequential files?

Answers were Sorted based on User's Feedback



Why we need datasets ratherthan sequential files?..

Answer / sagar

When you use sequential file as Source,at the time of
compilation it will convert to native format from
ASCII.where as,when you go for using datasets... conversion
is not required.Also, by default sequenctila files we be
processed in sequenc only.sequential files can accommodate
up to 2GB only.sequentila files does not support NULL
values....all the above can me overcome using dataset
stage....but selection is depeneds on the
requirement....suppose if you want to capture rejected
data....in that case you need to use sequential file or
fileset stage....

Is This Answer Correct ?    22 Yes 4 No

Why we need datasets ratherthan sequential files?..

Answer / kiran

First we Know about Seq file and Dataset.

Seg file is used Extract the from flatfiles and load into
flatfiles and limit is 2GB

Dataset is a intermidiate stage and it has paralism when
load data into dataset and it inprove the performanece.

Is This Answer Correct ?    22 Yes 11 No

Why we need datasets ratherthan sequential files?..

Answer / chiranjeevi.a

To over come the limitation of sequential file,espesially
sequential file: By default reads and writes sequentially
>memory limit is up to 2GB
>conversion is needed
>sourse stores the data out side of datastage
Data file:
>parallel process
>memory is unlimited
>No conversion is needed while reading the data(its
basically in native format).
>stores data inside the repositary

Is This Answer Correct ?    11 Yes 2 No

Why we need datasets ratherthan sequential files?..

Answer / narayana

file set is nothing but collection of sequential files. if sourse database is greater than 2 GB than prefer to use file set.
Data set is internal stage in datastage.the extension of data set is .ds it never used to extract data from client location .it is used as intermediate stage between two tables.
Sequential : 1)it supports all formats like txt,csv,xls,etc.
2)it is used to extract data from flat files from client location.
Data set:1)it supports only .ds format
2)it will never extract data from flat files from client location.

Is This Answer Correct ?    4 Yes 2 No

Why we need datasets ratherthan sequential files?..

Answer / pavan

datasets get processed in our local system rather than at
the server so performance gets enhanced in this case as
server is not loaded.

Is This Answer Correct ?    0 Yes 13 No

Post New Answer

More Data Stage Interview Questions

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,


how to abort the job its matain duplicates?

0 Answers   TCS,


Can you explain tagbatch restructure operator?

0 Answers  


Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,


What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,


CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  


what is advantages of snowflake when it is used?

3 Answers   IBM,


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  


Describe link sort?

0 Answers  


IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  


What is apt_config in datastage?

0 Answers  


col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,


Categories