"Fatal Error: APT_Decimal::assignFromString: the source string (322665901919233341505776723281119128249 ) is out of range for the decimal with precision 38."
Do you get the same error for this case also?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
The above error i got while i was converting that number to char by using TO_CHAR function [This is only way i was able view the data at source level] and then using DecimalFromString function in transformer and changing my target data type to Decimal[42,2].
But as per the info from prior post it was suggested that do it without converting it to char.
As suggested, Use TO_CHAR in the source and convert it into Char data type, pass it till the target, and User TO_NUMBER to convert it back to Decimal.
Have you just tried with Decimal[42,2] and run the job (not just view the data)? Did you got any error? Would you be able to find the data in output?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kumar_s wrote:As suggested, Use TO_CHAR in the source and convert it into Char data type, pass it till the target, and User TO_NUMBER to convert it back to Decimal.
Have you just tried with Decimal[42,2] and run the job (not just view the data)? Did you got any error? Would you be able to find the data in output?
AFAIK - There should be absolutely no need for the TO_CHAR / TO_NUMBER dance. And allegedly no need for any scale on the number. How about we stick with the suggestion of using something like Decimal[40] from end to end and see what happens? Or Decimal[42] it that floats your boat.
-craig
"You can never have too many knives" -- Logan Nine Fingers
I was suggesting to give a run and check the target with Decimal(42). But OP is very sticky with TO_CHAR that you suggested initially as the worst case.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'