Hi This is Vijay

How Can u Read the data from sequential file Parall'y?

Answers were Sorted based on User's Feedback



Hi This is Vijay How Can u Read the data from sequential file Parall'y?..

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

Hi This is Vijay How Can u Read the data from sequential file Parall'y?..

Answer / kiran

hai vijay.u can use above property for varible length also

Is This Answer Correct ?    3 Yes 0 No

Hi This is Vijay How Can u Read the data from sequential file Parall'y?..

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

Hi This is Vijay How Can u Read the data from sequential file Parall'y?..

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

Hi This is Vijay How Can u Read the data from sequential file Parall'y?..

Answer / navin

select 'Read Method=file pattern'.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,


what is data mapping

2 Answers  


How to Remove Duplicate using SQL?

0 Answers   CTS,


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

7 Answers   TCS,


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.

1 Answers  






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

0 Answers  


How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  


Give an idea of system variables.

0 Answers  


Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  


What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,


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 ?

0 Answers   Wipro,


How to manage date conversion in Datastage?

0 Answers  


Categories