NULL value in DECIMAL fields
Posted: Thu Jun 26, 2008 1:27 am
Hi,
We have 5 sequential files getting joined using Left outer join. Only the master record has the data and no child record is having data. But when the data is coming out from the JOIN stage is displaying 0 values into the decimal fileds that are coming from the child records. Where as our requirement is to display NULL value in the decimal field if there is no i/p data.
For this we tried using Nullable property for the respective decimal columns as YES. In this case the value is being displayed as NULL for the decimal fields those are having precision as > 0 but the job is being aborted with the following error message for the decimal fields those are not having any precision.
"Value larger than specified precision"
But the length of the field is defined properly through out all the stages including Oracle stage as per the defined structure of Oracle table.
Can anybody please help me out to solve this issue.
Thanks.
We have 5 sequential files getting joined using Left outer join. Only the master record has the data and no child record is having data. But when the data is coming out from the JOIN stage is displaying 0 values into the decimal fileds that are coming from the child records. Where as our requirement is to display NULL value in the decimal field if there is no i/p data.
For this we tried using Nullable property for the respective decimal columns as YES. In this case the value is being displayed as NULL for the decimal fields those are having precision as > 0 but the job is being aborted with the following error message for the decimal fields those are not having any precision.
"Value larger than specified precision"
But the length of the field is defined properly through out all the stages including Oracle stage as per the defined structure of Oracle table.
Can anybody please help me out to solve this issue.
Thanks.