Hi,
I tried to load data by simple direct mapping.
source column a (decimal(17,2))-12121212121212121.66
target column b (decimal(17,5))
The data are rejected to peak stage if i mapped directly. So i used DecimalToDecimal function , but that one also not worked.The data got loaded into DB2 target table but the value is 000000000000000.00.
Can anyone help me to rectify this asap? Thanks in advance.
decimal to higher decimal field mapping error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Mon Jun 28, 2010 5:15 am
- Location: pune
Re: decimal to higher decimal field mapping error
your data types should be
source column a (decimal(19,2))
target column b (decimal(22,5))
you wont need to use DecimalToDecimal fuction as this will be implicit conversion.
Also you are receiving value as 000000000000000.00, because you must have have set you default value as 0, because the record is getting rejected it is being replaced by default value
source column a (decimal(19,2))
target column b (decimal(22,5))
you wont need to use DecimalToDecimal fuction as this will be implicit conversion.
Also you are receiving value as 000000000000000.00, because you must have have set you default value as 0, because the record is getting rejected it is being replaced by default value