Data Integration
- Data Integration
- All Products
Property | Description |
---|---|
Name | Field or group name. In advanced mode or SQL ELT mode, this property is
always the field name. |
Level | Field or group level. In advanced mode or SQL ELT mode, the value is always
1. |
Occurs | Number of instances of the field or group in the source row. |
Type | The field datatype. The datatype can be either String or Number. In advanced mode, you can use any
primitive data type.
Doesn't apply to group-level fields. |
Precision | Total number of digits in a number. For example, the number 123.45 has a
precision of 5.The precision must be greater than or equal to 1. Doesn't apply to
group-level fields. |
Scale | Number of digits to the right of the decimal point of a number. For example,
the number 123.45 has a scale of 2. Scale must be greater than or equal to 0. The
scale of a number must be less than its precision. The scale may cause zero-filling
or truncation with rounding. For example, a scale of 5 causes 123.45 to be expressed
as "123.45000" while 123.456789 becomes "123.45679". Doesn't apply to group-level
fields. |