O'Reilly logo

Pentaho 3.2 Data Integration Beginner's Guide by María Carina Roldán

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

Chapter 12. Developing and Implementing a Simple Datamart

In this chapter you will develop a simple but complete process of loading a datamart while reviewing all concepts you learned throughout the book.

The chapter will cover the following:

  • Introduction to a sales datamart based on the Jigsaw puzzles database
  • Loading the dimensions of the sales datamart
  • Loading the fact table for the sales datamart
  • Automating what has been done

Exploring the sales datamart

In Chapter 9, you were introduced to star schemas. In short, a star schema consists of a central table known as the fact table, surrounded by dimension tables. While the fact has indicators of your business such as sales in dollars, the dimensions have descriptive information for the attributes of ...

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