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
- Safe minimum:
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 supported.
- Designer Cloud Enterprise Edition 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
This page has no comments.