Decimal Fields
A Decimal field is used to capture values that require decimal places. When a field is identified as a decimal field, then OIPA knows that the value entered into the field should be handled during processing as a decimal value. A decimal field should not be used to hold currency values.
When dealing with integers larger than 2,147,483,648 in math configuration, DATATYPE="DECIMAL" must be used.
Decimal Field in Palette
Define the Decimal Field
Drag and drop the Decimal field from the Palette window onto the Fields Pane. The Field Properties window will open, which provides the means for configuring the field. Enter the field information such as field name, display name, etc., by clicking in the field and typing the information.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices