Pentaho 3.2 Data Integration Beginner's Guide

Time for action – creating the time dimension dataset

In this tutorial we will create a simple dataset for a time dimension.

First we will create a stream with the days of the week:

1. Create a new transformation.
2. Press Ctrl+T to access the Transformation settings window.
3. Select the Parameters tab and fill it like shown in the next screenshot:
   
4. Expand the Job category of steps.
5. Drag a Get Variables step to the canvas, double-click the step, and fill the window like here:
   
6. After the Get Variables step, add a Split Fields step and use it to split the field week_days ...