Hi This is Vijay
How Can u Read the data from sequential file Parall'y?
Answers were Sorted based on User's Feedback
Answer / amar deep reddy
Hi Vijay,
You can do it by setting the 'No. of readers per node'
property value to >1. When you do this there will be n No.
of readers created in the node and each reader will read a
block of data from the sequential file.
If you have multiple input files (pattern), you can set the
property 'Read from multiple nodes' to 'yes'.
These 2 properties of sequential files are mutually
exclusive.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / kiran
hai vijay.u can use above property for varible length also
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vijaya
Hi Amar
What u send is right but "read from multi-nodes" is used for
fixed-width file only u can use "no.of readers per node" can
be used for variable length files
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vijay
Hi Amar ,
Thanks for giving Ans.
But As per i knows The Above two properties will be used
for Fixed with Flat files only.
I am asking aoutbt Varible lenth flat files?
| Is This Answer Correct ? | 1 Yes | 0 No |
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
what is normalization and denormalization
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the difference between account and directory options ?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
What is the difference between an operational datastage and a data warehouse?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
What are the features of datastage flow designer?