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 – automating the loading of the sales datamart

Suppose that every day you want to update your sales datamart by adding the information about the sales for the day before. Let's do some modifications to the jobs and transformations you created, so that the job can be run automatically.

In order to test the changes, you will have to change the date for your system. Set the current date to 2009-10-02.

  1. Create a new transformation.
  2. Drag to the canvas a Get system info step and fill it as shown:
    Time for action – automating the loading of the sales datamart
  3. With a Select values step, change the metadata of both fields. As type, put String and as format, yyyy-MM-dd.
  4. Add a Set variables step and use the ...

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