We were introduced to the Mapping Editor in the last chapter and discussed its features, so we'll just briefly review it here before using it to create a mapping. We will create mappings that are in the Design Center under an Oracle Database module. In our case, we have created an Oracle Database module called ACME_DWH
for our target database. So this is where we will create our mappings. In Design Center, navigate to the ACME_DW_PROJECT | Databases | Oracle | ACME_DWH | Mappings node if it is not already showing. Right-click on it and select New Mapping from the resulting pop-up. We will be presented with a dialog box to specify a name and, optionally, a description of our mapping. We'll name this mapping STAGE_MAP to reflect what it is being used for, and click on the OK button.
This will open the Mapping Editor window for us to begin designing our mapping. An example of what we will see next is presented here:
Unlike our first look at the Mapping Editor in the...