DATA SET problem in PX
Posted: Tue Sep 27, 2005 2:50 am
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 ?
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 ?