High precision data determines how large numbers are represented with greater
accuracy. The precision attributed to a number includes the scale of the number.
For example, the value 11.47 has a precision of 4 and a scale of 2. Large
numbers can lose accuracy because of rounding when used in a calculation that
produces an overflow. Incorrect results may arise because of a failure to
truncate the high precision data.
High precision
data values have greater accuracy. Enable high precision if you require accurate
values.
You enable high
precision on the properties tab of the session. The Integration Service
processes high precision data differently for bigint and decimal values.
No comments:
Post a Comment