Data Flow and Transformation-Code Generation in Mappings

Mappings provide a visual representation of the flow of the data and the operations performed on the data. Based on the ETL logic that you define in a mapping, OWB generates the code required to implement your design. OWB can generate code for the following languages:

• PL/SQL: PL/SQL stands for Procedural Language/Standard Query Language. It extends SQL by adding constructs found in procedural languages, resulting in a structural language that is more powerful than SQL.

• SQL*Loader: SQL*Loader is an Oracle tool for loading data from files into Oracle Database tables. It is the most efficient way to load large volumes of data from flat files.

• SAP ABAP: ABAP is a programming language for developing applications for the SAP R/3 system, a business application subsystem.

• Code Templates (CT mappings): For Code Template (CT) mappings, Warehouse Builder generates data extraction or other mapping code based on the contents of a Code Template.