Hi,
I am getting "Implicit conversion from source type "decimal[9,0]" to result type "decimal[7,0]": Possible range limitation." warning while running the job.
Actually the source table had decimal(13,9) and the target has decimal(9,2).
I just want to know wheter there is any transformer to propogate the value from 13,2 to 9,2.
There will be a change to get zero to append to the data if we transfome it from 13,2 to 9,2.
Please suggest if there is any way to do this.
Rd,
Ramesh.
Implicit conversion from source type, Possible range limit
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Wed Dec 26, 2012 1:13 pm
Re: Desing change
You can change the datatype length by using modify stage or transformer stage then this warning wont occur...
So is your source decimal(13,9) or decimal(13,2)?
While you can 'convert' one to the other (13,2 to 9,2), you're going to get that 'limitation' warning when going from a larger field to a smaller one since technically one may not fit into the other. If you are certain the values in the source will always fit the target, then you could simply demote the warning.
Otherwise, how do you plan to handle the truncation?
While you can 'convert' one to the other (13,2 to 9,2), you're going to get that 'limitation' warning when going from a larger field to a smaller one since technically one may not fit into the other. If you are certain the values in the source will always fit the target, then you could simply demote the warning.
Otherwise, how do you plan to handle the truncation?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers