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

How a routine is called in datastage job?

0 Answers  


what is repositery?

0 Answers   IBM,


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,


Name the command line functions to import and export the DS jobs?

0 Answers  


i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,






create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,


How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,


Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,


What is the difference between lookup and sparse lookup?

1 Answers  


Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

4 Answers   iGate, Thirdware,


Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,


Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  


Categories