O'Reilly logo

Oracle Warehouse Builder 11gR2: Getting Started 2011 by Bob Griesemer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SALES cube mapping

Turning our attention to the cube, we have one more mapping to create. It will be created in the same way as we created the previous maps, but let's call this one SALES_MAP. In this mapping, we will need to draw data from the POS_TRANS_STAGE table as input as we did for the other two dimension maps, and we will have the SALES cube as the output target to load our data. Let's drag each of these onto our mapping using Table Operator for the POS_TRANS_STAGE table and Cube Operator for the SALES cube.

The POS_TRANS_STAGE table is very familiar to us as we have used it for the two dimensions, but the SALES cube is new. It looks slightly different than the dimensions we worked with earlier in this chapter, so let's take a moment to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required