User`s guide
Transformation components
96 Sybase IQ ETL 4.1
4 Right-click and select OUT or TMP.
5 Select one of the attributes from the menu.
The added attribute can now be used for further assignments or calculations.
To delete transformation rules, right-click the desired line in the
Transformation Rule or Current Output Port column and select Remove.
To change the order of the transformation rules, right-click the desired line in
the Transformation Rule or Current Output Port column and select UP or
DOWN.
Sequence of processing transformation rules
The transformation rules are processed is sequential order. The processing
starts with the first transformation rule of the list. Consider the following
example:
In Line 3 you find a direct mapping between IN.PRICE and OUT.PRICE. Later
in line 7, there is a procedure that re-calculates the price and is thus overwriting
the assignment of the previous transformation rule.
Input Port Content area
Shows the current set of records available at the input port.
Output Port Content area
Shows the current set of records available at the output port.
Graph tab
The Graph tab shows the current mapping between the IN- and OUT-port
attributes.