Pentaho 3.2 Data Integration Beginner's Guide

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 ...