Transformation Guide

Back Next

Configuring the Expression Transformation

The Expression transformation has an input/output port for each source column. It passes column names to the SQL transformation based on the value of the PriceCode column.

The following figure shows the ports in the Expression transformation that return column names:

The Ports tab in the Edit Transformations dialog box contains the port name, datatype, precision, scale, and expression columns. The Ports tab also contains the Select transformation, Transformation type, Default value, and Description fields.

The SQL transformation has the following columns that contain the results of expressions:

UnitPrice_Query.
Returns the column name “MUnitprice,” “RUnitPrice,” or “WUnitprice” based on the whether the price code is “M,” “R,” or “W.”

DECODE(PriceCode,'M', 'MUnitPrice','R', 'RUnitPrice','W', 'WUnitPrice')

PkgPrice_Query.
Returns the column name “MPkgPrice,” “RPkgPrice,” or “WPkgPrice,” based on the whether the price code is “M,” “R,” or “W.”

DECODE(PriceCode,'M', 'MPkgPrice','R', 'RPkgPrice','W', 'WPkgPrice')

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Configuring the Expression Transformation

Configuring the Expression Transformation