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 that you will find in the Input category of steps, 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, where you saved the transformation that loads the fact table.
7. Test the transformation by providing valid and invalid arguments to see that it works as expected.
8. Create a job and save it in the same folder in which you saved the job that loads the dimensions.
9. Drag to the canvas a START and two...