For most transformations, the Properties dialog will have an Output tab. For Retain transformations, the Properties dialog has no tabs but directly displays Output options.
Clicking on Output leads to the following display and options.
Variable Transformation > Input > Output Properties
- Output Name/Suffix — If this field appears, you can rename (assign an alias to) the column, if needed. Only in the case of Design Code, where multiple columns are created, does this appear as Output Suffix because it follows the prefix representing the value being encoded, separated by an underscore character.
-
Output Type — When this field appears, it lets you select output type. The default is Generate Automatically, but you can also select the following types. Depending on the type selected, one or more length fields may also be presented.
- BIGINT
- BYTEINT
- CHAR
- DATE
- DECIMAL
- FLOAT
- INTEGER
- NUMBER
- SMALLINT
- TIME
- TIMESTAMP
- VARCHAR
- Column Attributes — One or more column attributes can be entered here in a free-form manner to be used when an output table is created. They are placed as-entered following the column name in the CREATE TABLE AS statement. This can be particularly useful when requesting data compression for an output column, which might look like the following: COMPRESS NULL.
- Description — An optional description may be specified for each transformation.