Using the correct data type for math operations helps ensure expected results from your transformations and jobs. The Number, BigNumber, and Integer types offer specific solutions for different computing needs. The following table highlights the behaviors and possible uses for each data type. For information about the proper method to round or truncate numbers, see Applying calculations and rounding.
| PDI data type | Description |
|---|---|
| Number |
Use for general math with real numbers:
|
| BigNumber |
Use to get exact results from math of decimal numbers:
|
| Integer |
Use for math without a fraction or a decimal component:
|