Now we have our staging table deployed to the target database, the POS_TRANS_STAGE
table, and have successfully deployed the STAGE_MAP
mapping to load that table from our source database. This means we now have enough of our target database deployed to be able to execute the STAGE_MAP
mapping to load the staging table. Let's do that now so that we will have progressed through the entire process once. Loading the staging table is the first step we have to take to load our database before we can proceed to load the actual target dimensions and cube. After we execute this mapping, we can go back and deploy the remaining objects, and execute them to load the dimensions and cube.
The process of executing a mapping can be performed from the Design Center as well as from the Control Center Manager. The process of executing is very similar to deploying. Results are displayed in the Control Center Jobs window, which is the same as that of the deployment results, but on a different tab,...