A transformation process is a high-level process, which models the extraction of data from input sources, its transformation, and loading to output sources. Input and output sources are linked to databases, flat files, XML documents, or business processes.
The transformation process can contain:
-
Data Transformation Diagrams – identify data transformation tasks, which model the extraction, transformation, and loading of data. For detailed information, see Building Data Transformation Diagrams.
-
Transformation Control Flow Diagrams – detail the order in which data transformation tasks are executed. For detailed information, see Building Transformation Control Flow Diagrams.
Press ctrl and double-click a transformation process symbol to open its diagram. When several diagrams are available, a selection dialog box opens to let you select the diagram you want.
In the following example, the Small Corp, Acme, Small Corp Role, and Acme Role input sources are transformed by the Data Fusion and Reorganization transformation process, and then loaded to the Giant Corp output sources:
