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

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

Hi This is Vijay

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

Question Posted / goudvijay

5 Answers
14093 Views
Semantic Space, I also Faced
E-Mail Answers

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

What are the different common services in datastage?

0 Answers

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers

Define data aggregation?

0 Answers

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

how to call sequential generator in datastage?

1 Answers IBM,

How can you join flat file, oracle as a sources?

4 Answers IBM,

what is the use of surogate key in datastage

3 Answers

How to enter a log in auditing table whenever a job get finished?

2 Answers L&T,

What is process model?

0 Answers

What are the differences between datastage and informatica?

0 Answers

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers

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,

For more Data Stage Interview Questions Click Here