12.2.4 Transformation Tab
Table 12-3 Transformation Tab Description
Fields | Description Fields marked in red asterisk(*) are mandatory |
---|---|
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. |