Interested to Buy Any Domain ? << Click Here >> for more details...
Why we need datasets ratherthan sequential files?
- 5 Answers
- 31862 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
State the difference between an operational datastage and a data warehouse?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
how to load meta data
What could be a data source system?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
difference between server shared container and parallel shared container
How rejected rows are managed in datastage?
what is the unix script to run the job? Please mention commands which we use often?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
How many types of stage?
Teradata 
