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 |
How a source file is populated?
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
Define repository tables in datastage?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
count number of deptno in a emp table?
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
How to RD using transformer?
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.
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
What is aggtorec restructure operator?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?