Chapter 9. Performing Advanced Operations with Databases

In this chapter you will learn about advanced operations with databases. The first part of the chapter includes:

  • Populating the Jigsaw puzzle database so that it is prepared for the rest of the activities in the chapter
  • Doing simple lookups in a database
  • Doing complex lookups

The second part of the chapter is fully devoted to datawarehouse-related concepts. The list of the topics that will be covered includes:

  • Introducing dimensional modeling
  • Loading dimensions

Preparing the environment

In order to learn the concepts of this chapter, a database with little or no data is useless. Therefore, the first thing you'll do is populating your Jigsaw puzzle database.

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.