Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Outdated release! Latest docs are Release 8.2: Decimal Data Type

   

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

Notes:

  • 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.
  • Trifacta utilizes Java's Float data type for its Decimal data validation, which may result in some loss of precision in rare cases.

Examples:

  • 123.45
  • 3000.00
  • 1.2345678E+22
  • 7.4423e-12
  • -4.123e+12

  • No labels

This page has no comments.