Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Excerpt

Decimal data type applies to floating points up to 15 digits in length.


  • Punctuation such as commas and dollar signs ($) are not supported. These markers must be removed from numeric values through transform steps before you can change the type to Decimal.
  • The following range is considered safe for values of this type. There may be inconsistencies in output for values outside this range:
    • Safe minimum:  4.9406564584124654e-324
    • Safe maximum: 1.7976931348623157e+308

...

  • Decimal values that are longer than 15 digits are treated as String values and may appear as mismatched values in a Decimal column.
  • Scientific notation is not supported.
  • D s product
     utilizes Java's Float data type for its Decimal data validation, which may result in some loss of precision in rare cases.

...