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:
    Time for action—creating the time dimension dataset
  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:
    Time for action—creating the time dimension dataset
  6. After the Get Variables step, add a Split Fields step and use it to split the field week_days ...

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.