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 dimensions for the sales datamart

In this section, you will load each dimension for the sales datamart and enclose them into a single job. Before starting, check the following things:

  • Check that the database engine is up and that both the js and the js_dw databases are accessible from PDI.
  • If your time dimension table lk_time has data, truncate the table. Remember that you can do it by right-clicking on the table in the database explorer and selecting the Truncate Table option.

    Tip

    You may reuse the js_dw database in which you have been loading data in previous chapters. There is no problem with that. However, dropping the database and creating the tables again is preferred so that you can see how the entire process works. ...

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