3.4 Transformation Tab

Table 3-3 Transformation Tab Description

Fields	Description
Transformation Type	A drop-down listing the different types of transformation supported. Currently, only Aggregation is supported.
If the Transformation Type is selected as None:
Derived Data Elements
Name	Name of the derived field in the EDD. NOTE: Field names must not be more than 30 characters.
Type	Shows the Data type of the field. Example: Varchar2, Number, Date, and so on.
Expression	When you select the Add option, the Specify Expression window is displayed. Here, you can select the required entities, functions, and operators. That is, you can write your expression. Enter the field name and click OK. Then the newly created field name is listed.
If the Transformation Type is selected as Aggregation:
Derived Data Elements
Name	Name of the derived field in the EDD. Note: Field names must not be more than 30 characters.
Type	This shows the Data type of the field. Example: Varchar2, Number, Date, and so on.
Expression	When you select the Add option, the Specify Expression window is displayed. Here, you can select the required entities, functions, and operators. That is, you can write your expression. Enter the field name and click OK. Now the newly created field name is listed.
Aggregation Properties
Group By	This is available when Aggregation is selected.
Having	This is available when Aggregation is selected.