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

Summary

We saw how to create a mapping in the Warehouse Builder, including how to design a staging area table, build it with the Table Editor, design a mapping to populate it, and then create the mapping using source and target operators, and the intervening Joiner and Aggregator operators. We also got to use a Transformation Operator.

Now that we have completed our staging table mapping, we need to design mappings to get our dimensions and cube populated from the data in the staging table. We'll do that in the next chapter while taking a look at transformations, which are a key feature of the Warehouse Builder for loading and cleaning up data.

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