Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff between sequential file and fileset stages?
- 3 Answers
- 26791 Views
- I also Faced
- E-Mail Answers
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
How many areas for files does datastage have?
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 ?
How many types of sorting methods are available in datastage?
What is the project in datastage?
How a routine is called in datastage job?
What are constraints and derivations?
What are stage variables, derivations and constants?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what are the devoleper roles in real time? plz tell i am new to datastage....
root tree will find which is server job and which is parallel job?
What is the difference between datastage and informatica?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
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
