Data types are part of the metadata and are mandatory. Every field in a PDI dataset must have a data type. You have already used some of the most common data types, namely String, Date, and Integer, but the full available list of supported data types is a bit longer. The following table summarizes them all:
PDI data type |
Java data type |
Description |
String |
java.lang.String |
Unlimited length text |
Integer |
java.lang.Long |
A signed long (64-bit) integer |
Number |
java.lang.Double |
A double precision floating point value |
BigNumber |
java.math.BigDecimal |
Unlimited precision number |
Date |
java.util.Date |
A date-time value with millisecond precision |
Timestamp |
java.sql.Timestamp ... |