Previous
Next
Previous |
Next |
The mapping operator is the basic design element for a mapping. As you design a mapping, you select operators from the Mapping Editor palette, and you can visually drag them onto the work area or canvas. Operators handle how to represent sources and targets in the data flow. Operators also define how to transform the data from source to target. The operators you select affect how you will design the mapping.
Based on the operators you select, OWB assigns the mapping to one of the following Mapping Generation Languages:
PL/SQL. OWB generates PL/SQL code for all mappings that do not contain either a flat file operator as a source, or a SAP/R3 source. Design considerations for PL/SQL mappings depend on whether you specify a row-based or set-based operating mode.
SQL*Loader. When you define a flat file operator as a source, OWB generates SQL*Loader code. To design a SQL*Loader mapping correctly, follow the guidelines described in Using Flat File Source and Target Operators in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.
ABAP (SAP-based script). When you define a SAP/R3 source, OWB generates ABAP code. For mapping design considerations for SAP sources, see "Creating SQL*Loader, SAP, and Code Template Mappings" in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.
Each of these languages require you to adhere to certain rules when designing a mapping.