Let's begin by creating a new mapping called STORE_MAP
. We'll follow the procedure in the previous chapter to create a new mapping. In the Design Center, we will right-click on the Mappings node of the ACME_DW_PROJECT | Databases | Oracle | ACME_DWH database and select New.... Enter STORE_MAP for the name of the mapping and we will be presented with a blank Mapping Editor window. In this window, we will begin designing our mapping to load data into the STORE
dimension.
In the last chapter, we loaded data into the POS_TRANS_STAGE
staging table with the intent to use that data to load our dimensions and cube. We'll now use this POS_TRANS_STAGE
table as our source table. Let's drag this table onto the mapping from the Explorer window. Review the Adding source tables section of the previous chapter for a refresher if needed.
The target for this mapping is going to be the STORE
dimension, so we'll drag this dimension from Databases | Oracle | ACME_DWH...