In this tutorial, we will load the PUZZLE dimension for the first time. This is how we proceed:
- Create a new Transformation.
- Drag a Table input step to the work area and double-click on it.
- As Connection, select js. In the SQL area, type the following query:
SELECT pro_code , man_code , pro_name , pro_theme FROM products WHERE pro_type LIKE 'PUZZLE%'
- Click on OK.
- Add an Add constants step and create a hop from the Table input step toward it.
- Use the step to add a Date field named changedate. As format, type dd/MM/yyyy and as value, type 01/10/2017.
- After the Add constants step, add a Dimension lookup/update step. You will find it in the Data Warehouse category of steps.
- Double-click on the Dimension ...