Chapter 12. Developing and Implementing a Simple Datamart

In this chapter, you will implement a simple but complete process of loading a datamart. The sections will not only teach you about this interesting subject and how PDI can help in the process, but will also allow you to review all concepts learned through the book. Even more, following the step-by-step instructions in this chapter will help you be confident that you master the tool.

This 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, Performing Advanced Operations with Databases ...

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.