In Chapter 2, Getting Familiar with Spoon, you learned how to run transformations in production environments by using the Pan
command-line utility. There is a counterpart tool for running jobs: the Kitchen
command. Using Kitchen
is no different than using Pan
. The tool comes in two flavors: Kitchen.bat
and Kitchen.sh
, for use in a Windows or a Linux system, respectively. Let's review the different options. The simplest way to run a job is to indicate the full path of the kjb
file. You do so with the following syntax:
Kitchen.bat /file=<kjb file name>
You can also use the following command:
Kitchen.sh /file=<kjb file name>
For example, if you want to load the datamart from the command line in Windows, you can do so by running the following command:
Kitchen.bat /file=c:/pdi/load_datamart.kjb
Kitchen
can receive the same parameters that Pan
does; the most common are as follows:
level
: This indicates the log level. The syntax for setting the log level...