VERIFIED SOLUTION i
'Decimal result is too large, increase field precision' error message during plan execution in Sagent
While running Sagent plan that uses 'ToDecimal' function on string input in the expression calculator transform, 'Decimal result is too large, increase field precision' error message is encountered. The plan works fine if the input is 'Double' type.
It could be caused when 'ToDecimal' function is called on a String column in expression calculator and if the exponent (size of the string column as input to Expression Calculator) is greater than precision set in the expression.
UPDATED: October 1, 2018
Increase the precision of 'ToDecimal' function for the affected column more than the exponent.
Product Feature: Expression Calculator
- No Downloads