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 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.
