Packt+ | Advance your knowledge in tech

You're reading from Learning Pentaho Data Integration 8 CE An end-to-end guide to exploring, transforming, and integrating your data across multiple sources

Product type Paperback

Published in Dec 2017

Publisher Packt

ISBN-13 9781788292436

Length 500 pages

Edition 3rd Edition

Languages

Java

Tools

Pentaho

Concepts

Data Processing

Author (1):

María Carina Roldán

View More author details

Table of Contents (17) Chapters

Preface

1. Getting Started with Pentaho Data Integration FREE CHAPTER

2. Getting Started with Transformations

3. Creating Basic Task Flows

4. Reading and Writing Files

5. Manipulating PDI Data and Metadata

6. Controlling the Flow of Data

7. Cleansing, Validating, and Fixing Data

8. Manipulating Data by Coding

9. Transforming the Dataset

10. Performing Basic Operations with Databases

11. Loading Data Marts with PDI

12. Creating Portable and Reusable Transformations

13. Implementing Metadata Injection

14. Creating Advanced Jobs

15. Launching Transformations and Jobs from the Command Line

16. Best Practices for Designing and Deploying a PDI Project

Loading dimensions with data

A dimension is an entity that describes your business; customers and products are examples of dimensions. A dimension table, no surprises here, is a table that contains information about one or more dimensions. In this section, you will learn to load dimension tables, that is, fill dimension tables with data. The following are the topics covered:

Learning the basics of dimensions
Loading a time dimension
Loading slowly changing dimensions
Loading other kinds of dimensions

Learning the basics of dimensions

Dimensions are sets of attributes used to describe a business. A list of products along with their shape, color, or size is a typical example of dimension. Dimensions are one of the basic blocks of a data warehouse or data mart.

A dimension has the purpose of grouping, filtering, and describing data. Think of a typical report you would like to have—sales grouped by region, by customer, and method of payment that are ordered by date. The by word lets you identify potential...