Hi, I'm Ask INFA!
What would you like to know?

ASK INFAPreview

Please to access Ask INFA.

Search

Transformations

Transformations

Back Next

Variable fields

Variable fields

Create a variable field to define calculations that you want to use within the Expression transformation.

The following table describes the properties you can define when you create a variable field:

Property	Description
Name	Name of the field.
Type	The data type of the field.
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. You cannot specify a decimal field precision greater than 38.
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".
Description	Optional. Description of the field. The description can contain up to 4000 characters.

Expression fields

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.