Time for action—loading the fact table using a range of dates obtained from the command line

Now you will get the range of dates from the command line and load the fact table using that range:

  1. Create a new transformation.
  2. With a Get system info step, get the first two arguments from the command line and name them date_from and date_to.
  3. By using a couple of steps, check that the arguments are not null, have the proper format (yyyy-mm-dd), and are valid dates.
  4. If something is wrong with the arguments, abort.
  5. If the arguments are valid, use a Set variables step to set two variables named DATE_FROM and DATE_TO.
  6. Save the transformation in the same folder you saved the transformation that loads the fact table.
  7. Test the transformation by providing valid and ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.