Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Expression transformation
  7. Filter transformation
  8. Input transformation
  9. Joiner transformation
  10. Lookup transformation
  11. Mapplet transformation
  12. Normalizer transformation
  13. Output transformation
  14. Rank transformation
  15. Router transformation
  16. Sequence transformation
  17. Sorter transformation
  18. SQL transformation
  19. Union transformation

Transformations

Transformations

Input macro field

Input macro field

Create an input macro field to represent the input that you want to use in an expression macro. Depending on the type of macro, the input can be fields or constants.
The following table describes the properties you can define when you create an input macro field:
Property
Description
Name
Name of the input macro 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".
Not editable for all data types.
Description
Optional. Description of the field. The description can contain up to 4000 characters.

0 COMMENTS

We’d like to hear from you!