DATA SET problem in PX

[Nageshsunkoji]

Hi all,

I am facing one strange problem with Dataset.In one of my output Dataset i have one column like ACCOUNT :DECIMAL: Length 7 and scale 4.In my output Dataset i am getting the proper value like 87.40.While, when i am using the same Dataset as a input in one of my other jobs,all my columns are showing proper values except ACCOUNT DECIMAL 7 scale 4 column.Its not showing any value in the specific column i am only getting null values.But other column with same datatype specification are getting populated properly. All the metadata and file path is same for both datasets. Can any body help me to solve this problem ?

[shails]

This problem occurs if there is any record whose column length is greater than the one specified i,e 7,4. Try the same job by increasing the precision value say 11,4 or 10,4 or 9,4. This will help you.