Why it is in Sequntial stage? When u read data Fixed format

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
BMSK
Participant
Posts: 41
Joined: Wed Feb 06, 2008 7:00 am
Location: Bangalore

Why it is in Sequntial stage? When u read data Fixed format

Post by BMSK »

When data is fixed format

1)Format
Record level
Record length = fixed
Field defaults
Delimiter = none

The first recod is correct remaing rows are cmng zero or unmatched data.


The same data can be read in differnt format

2)Format
Record level
Final delimiter = end
Field defaults
delimter = none

the outcome of this result correct.

When u select fixed format its showing wrong data, If u select second method its showing correct data.

can anyone tell why it is?

thanks
BMSK
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

In short because your data do not match your metadata in the first case. Without seeing examples of your data and your record schema(s) it is not possible to comment further.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
BMSK
Participant
Posts: 41
Joined: Wed Feb 06, 2008 7:00 am
Location: Bangalore

Post by BMSK »

Hi Ray,

here the input data

the metadta colum are
rectype(1)
accnum(3)
sal(5)
tran(3)

Input data is

123450000400
134525000500
234510000300
312445000200

the out of Fixed format is

When go for the first method

rectype acc sal tran
1 234 50000 400
0 0 23451 0
0 300 267 830
0 3 0 124


When go for the second method

rectype acc sal tran
1 234 50000 400
1 345 25000 500
2 345 10000 300
3 124 50000 200

thanks
BMSK
dsusr
Premium Member
Premium Member
Posts: 104
Joined: Sat Sep 03, 2005 11:30 pm

Post by dsusr »

Change the length of Record Length =Fixed to Record Length=12.
Post Reply