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

ASK INFAPreview

Please to access Ask INFA.

Search

Transformations

Transformations

Back Next

Output fields

Output fields

Create an output field to define a calculation that does not require an expression macro.

The following table describes the properties you can define when you create an output field:

Properties	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".
Default Value	The default value tells the mapping task what to do when the transformation encounters output errors. You can enter one of the following values: ERROR('transformation error'). When a transformation error occurs, the mapping task skips the row and writes the error to the session log or row error log. A constant or constant expression. The mapping task replaces the error with the constant or constant expression. Nothing is written to the logs. ABORT. Transformation aborts and the mapping task writes a message to the session log. Default is ERROR('transformation error'). Data Integration validates the output field default value when you save or validate the mapping. If you enter an invalid value, the Mapping Designer marks the mapping as not valid.
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.