Transformation is the process of manipulating data. Any manipulation beyond copying is a transformation. Examples include cleansing, aggregating, and integrating data from multiple sources. Transforming the data is executed after the load process is finished. The transformation script consists of one or more script files. The list of the script files is shown in Files, as shown in Figure 5‑1. The Main file is the first file executed after data load. To access this file, you select Main file.
Figure 5‑1 Transforming data
A new form for creating a new transaction opens on the right side of the Main file area. You can resize each of the three areas on the Transform screen by positioning your pointer on the three-dot line separating the areas, and dragging the pointer in the desired direction.
Ignoring items during the transform process
Users can choose to have items (tables, instructions) ignored during the transform process in the Transform tab (items can also be ignored during the loading process using the Data tab). Clicking on the “check” symbols in the column beside the “Command” column in the Transform tab allows Users to have chosen elements ignored by the transform process (toggling them on and off). The contents of ignored item rows appear in italics.
