O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – loading the sales fact table by looking up dimensions

Let's load the sales fact, ft_sales, with sales information for a given range of dates. Before performing this section, be sure that you have already loaded the dimensions. You did it in the previous section.

Also, check that the database engine is up and that both the js and the js_dw databases are accessible from PDI. If everything is in order, you are ready to start:

  1. Create a new transformation.
  2. Drag a Table input step to the canvas.
  3. Double-click on the step. As Connection, select js – the connection to the operational database.
  4. In the SQL frame, type the following query:
    SELECT i.inv_date ,d.man_code ,cu.city_id ,pr.pro_type product_type ,b.buy_desc ,p.pay_desc ,sum(d.cant_prod) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required