Design ETL Logic

This procedure describes how to design mappings that define the flow of data from a source to target objects.

To design ETL logic: 

1. In the Projects Navigator, expand the Oracle target module, right-click the Mappings node and select New.

   • The Mapping Editor enables you to define the flow of data visually. You can drag-and-drop operators onto the canvas, and draw lines that connect the operators. Operators represent both data objects and functions such as filtering, aggregating, and so on.

   See detailed procedures in Defining Mappings in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide, concluding with generating the code for the mapping.

2. Manage dependencies between mappings. See Designing Process Flows in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.