官术网_书友最值得收藏!

Time for action – running the matches transformation from a terminal window

Let's suppose that the name of your transformation is matches.ktr. In order to run the transformation from a terminal, follow these instructions:

  1. Open a terminal window, and go to the directory where Kettle is installed. If your system is Windows, and supposing that Kettle is installed in C:\pdi-ce, type:
    C:\pdi-ce>Pan.bat /file=c:\pdi_labs\matches.ktr europe_201210.txt
  2. On Unix, Linux, and other types of systems, supposing that Kettle is installed under /home/your_dir/pdi-ce/, type:
    /home/your_dir/pdi-ce/pan.sh /file=/home/your_dir/pdi_labs/matches.ktr europe_201210.txt
  3. If your transformation is in another folder, modify the command accordingly.
  4. While the transformation runs you will be able to see the progress in the terminal:
  5. Check the output file. The contents of europe_201210.txt should be at the end of the matches.txt file.

What just happened?

You executed a transformation with Pan, the program that runs transformations from terminal windows. As a part of the command you specified the full path of the transformation file and provided the name of the file to process, which was the only argument expected by the transformation. As a result, you got the same output as if you had run the transformation from Spoon: a small file appended to the global file.

When you are designing transformations, you run them with Spoon; you don't use Pan. Pan is mainly used as part of batch processes, for example, processes that run every night in a scheduled fashion.

Note

Appendix B, Pan and Kitchen – Launching Transformations and Jobs from the Command Line gives you all the details about using Pan.

Have a go hero – finding out system information

Create a transformation that writes to the log the following information:

  • System date
  • Information about Kettle: version, build version, and build date
  • Name of the transformation you're running

Run the transformation both from Spoon and from a terminal window.

主站蜘蛛池模板: 德钦县| 安顺市| 孝昌县| 黄梅县| 浠水县| 哈尔滨市| 昌黎县| 离岛区| 宁晋县| 冀州市| 安达市| 永清县| 祁东县| 兰溪市| 青海省| 柳江县| 启东市| 襄城县| 鹤庆县| 砀山县| 开远市| 资兴市| 务川| 临泉县| 双流县| 竹北市| 阿巴嘎旗| 鹤庆县| 太保市| 建平县| 光山县| 阳西县| 改则县| 南木林县| 深泽县| 巨野县| 深泽县| 海晏县| 平塘县| 报价| 太仆寺旗|