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

PRODUCT mapping

The mapping for the PRODUCT dimension will be similar to the STORE mapping, so we won't cover it in as much detail here. We'll open the Design Center if it's not already open and create a new mapping just as we did for the STORE mapping earlier and the STAGE_MAP mapping from the last chapter. We'll name this mapping PRODUCT_MAP.

The source for the data will again be our staging table, POS_TRANS_STAGE, just as it was for the STORE mapping. Only the target will change as we're loading the PRODUCT dimension this time. We'll drag the POS_TRANS_STAGE table from the Projects window and drop it on the left of the mapping, and drag the PRODUCT dimension from ACME_DWH | Dimensions and drop it to the right of the mapping. Not surprisingly, ...

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