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

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.

主站蜘蛛池模板: 南昌县| 海安县| 岱山县| 霞浦县| 辽阳市| 延津县| 上犹县| 仙居县| 临泽县| 仲巴县| 荥阳市| 金阳县| 土默特左旗| 昌都县| 邯郸县| 仪征市| 甘谷县| 巢湖市| 绵竹市| 潞城市| 神池县| 阜平县| 上饶市| 尖扎县| 饶阳县| 高淳县| 大关县| 辽源市| 长白| 永寿县| 浙江省| 剑阁县| 新河县| 兖州市| 库伦旗| 林口县| 花莲县| 福泉市| 连城县| 友谊县| 常熟市|