Time for action – creating the time dimension dataset
In this tutorial, we will create a simple dataset for a time dimension.
In Chapter 2, Getting Started with Transformations, you created a transformation that generated a dataset with one row by date in a date range. In this tutorial, we will reuse that work.
First, we will create a stream with the days of the week:
- Create a new transformation.
- Press Ctrl + T or right-click on the canvas and select Transformation settings to access the Transformation properties window.
- Select the Parameters tab and fill it as shown in the following screenshot:
- Expand the Job category of the steps.
- Drag a Get Variables ...