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 |
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
what is data mapping
How to Remove Duplicate using SQL?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How you Implemented SCD Type 1 & Type 2 in your project?
Give an idea of system variables.
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
What is exact difference between Parallel Jobs and server Jobs..
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 to manage date conversion in Datastage?