what is the diff between sequential file and fileset stages?
Answer Posted / san
Seq. stage:
--------------
Seq file stage by default run in sqe. mode and you define a
seq file stage to run in parallel mode.. by setting option
"number of readers per node" > 1.
Seq. FS is used to read or write data from .txt .dat format
files. But the limit of seq stage is 2 GB.
Fileset stage:
---------------
by default Fileset stage run in parallel mode. more than 2GB
data can be stored. But the fileset hold to typse of information
i) files descriptor -> points to metadata, data location
ii) contains the data, contains multiple files if your using
more than one nodes config file
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the different plug-ins stages used in your projects?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Is the value of staging variable stored temporarily or permanently?
What is datastage?
What are the partitioning techniques available in link partitioner?
What are some different alternative commands associated with "dsjob"?
Nls stands for what in datastage?
How do you generate sequence number in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is a merge?
what is the use of materialized view?
Define Routines and their types?
Which warehouse using in your datawarehouse
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
How can we improve the performance in datastage?