Kettle从入门到精通文档_kettle入门与实战pdf,kettle从入门到精通-其它文档类资源-CSDN文库

Kettle

文档

4星 · 超过85%的资源

所需积分/C币: 4

浏览量·4.0k

ZIP

24.52MB

2017-08-17 15:25:21 上传

身份认证购VIP最低享 7 折!

评论收藏举报

共9个文件

pdf：5个

doc：4个

资源推荐

资源详情

资源评论

收起资源包目录

Kettle学习资料大全.zip （9个子文件）

Kettle学习资料大全

Kettle相关内容及实验（周博翔）.doc 1.28MB

KETTLE.pdf 5.35MB

pentaho-kettle_4.2.1基础教程.doc 820KB

kettle各个组件用法.doc 1.93MB

ETL工具KETTLE实例手册.pdf 974KB

数据库原理及应用（SQL+Server版）（2012最新版）.pdf 7.49MB

ETL工具Kettle用户手册.pdf 10.31MB

kettle入门例子大全.doc 1.79MB

Kettle培训手册.pdf 1.08MB

<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/9938298/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9938298/bg1.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">技术资料，【Kette3.0 用户手册】 </div><div class="t m0 x1 h3 y2 ff3 fs0 fc0 sc0 ls0 ws0">©深圳市神盾信息技术有限公司，2008 第 1 页/共 202 页 </div><div class="t m0 x2 h4 y3 ff1 fs1 fc0 sc1 ls2 ws0">Kettle 3.0 用户手册 </div><div class="t m0 x1 h5 y4 ff1 fs2 fc1 sc2 ls3 ws0">目录</div><div class="t m0 x1 h6 y5 ff1 fs3 fc0 sc0 ls4 ws0">Kettle 3.0 用户手册 ...................................................................................................................... 1</div><div class="t m0 x1 h6 y6 ff1 fs3 fc0 sc0 ls4 ws0">Kettle 3.0 用户手册 ...................................................................................................................... 6</div><div class="t m0 x1 h6 y7 ff2 fs3 fc0 sc0 ls6 ws0">1. Kettle 介绍 ................................................................................................................................ 6</div><div class="t m0 x3 h6 y8 ff2 fs3 fc0 sc0 ls8 ws0">1.1 什么是 kettle ............................................................................................................. 6</div><div class="t m0 x3 h6 y9 ff2 fs3 fc0 sc0 ls8 ws0">1.2 Kettle 的安装 ............................................................................................................ 6</div><div class="t m0 x3 h6 ya ff2 fs3 fc0 sc0 ls8 ws0">1.3 运行 Spoon ............................................................................................................... 6</div><div class="t m0 x3 h6 yb ff2 fs3 fc0 sc0 ls8 ws0">1.4 资源库 ....................................................................................................................... 6</div><div class="t m0 x3 h6 yc ff2 fs3 fc0 sc0 ls8 ws0">1.5 资源库自动登录 ....................................................................................................... 7</div><div class="t m0 x3 h6 yd ff2 fs3 fc0 sc0 ls8 ws0">1.6 定义 ........................................................................................................................... 8</div><div class="t m0 x4 h6 ye ff2 fs3 fc0 sc0 ls8 ws0">1.6.1 转换 ................................................................................................................... 8</div><div class="t m0 x4 h6 yf ff2 fs3 fc0 sc0 ls8 ws0">1.6.2 任务 ................................................................................................................... 8</div><div class="t m0 x3 h6 y10 ff2 fs3 fc0 sc0 ls8 ws0">1.7 选项 ........................................................................................................................... 9</div><div class="t m0 x4 h6 y11 ff2 fs3 fc0 sc0 ls8 ws0">1.7.1 General 标签 ................................................................................................... 10</div><div class="t m0 x4 h6 y12 ff2 fs3 fc0 sc0 ls8 ws0">1.7.2 Look Feel 标签 ............................................................................................... 11</div><div class="t m0 x3 h6 y13 ff2 fs3 fc0 sc0 ls8 ws0">1.8 搜索元数据 ............................................................................................................. 12</div><div class="t m0 x3 h6 y14 ff2 fs3 fc0 sc0 ls8 ws0">1.9 设置环境变量 ......................................................................................................... 13</div><div class="t m0 x1 h6 y15 ff2 fs3 fc0 sc0 ls6 ws0">2. 创建一个转换或任务 ............................................................................................................. 13</div><div class="t m0 x1 h6 y16 ff2 fs3 fc0 sc0 ls6 ws0">3. 数据库连接(Database Connections) ...................................................................................... 14</div><div class="t m0 x3 h6 y17 ff2 fs3 fc0 sc0 ls8 ws0">3.1 描述 ......................................................................................................................... 14</div><div class="t m0 x3 h6 y18 ff2 fs3 fc0 sc0 ls8 ws0">3.2 设置窗口 ................................................................................................................. 14</div><div class="t m0 x3 h6 y19 ff2 fs3 fc0 sc0 ls8 ws0">3.3 选项 ......................................................................................................................... 14</div><div class="t m0 x3 h6 y1a ff2 fs3 fc0 sc0 ls8 ws0">3.4 数据库用法 ............................................................................................................. 15</div><div class="t m0 x1 h6 y1b ff2 fs3 fc0 sc0 ls6 ws0">4. SQL 编辑器(SQL Editor) ....................................................................................................... 16</div><div class="t m0 x3 h6 y1c ff2 fs3 fc0 sc0 ls8 ws0">4.1 描述 ......................................................................................................................... 16</div><div class="t m0 x3 h6 y1d ff2 fs3 fc0 sc0 ls8 ws0">4.2 屏幕截图 ................................................................................................................. 16</div><div class="t m0 x3 h6 y1e ff2 fs3 fc0 sc0 ls8 ws0">4.3 局限性 ..................................................................................................................... 16</div><div class="t m0 x1 h6 y1f ff2 fs3 fc0 sc0 ls6 ws0">5. 数据库浏览器(Database Explorer) ........................................................................................ 17</div><div class="t m0 x3 h6 y20 ff2 fs3 fc0 sc0 ls8 ws0">5.1 屏幕截图 ................................................................................................................. 17</div><div class="t m0 x3 h6 y21 ff2 fs3 fc0 sc0 ls8 ws0">5.2 描述 ......................................................................................................................... 17</div><div class="t m0 x1 h6 y22 ff2 fs3 fc0 sc0 ls6 ws0">6. 节点连接（Hops） ................................................................................................................ 18</div><div class="t m0 x3 h6 y23 ff2 fs3 fc0 sc0 ls8 ws0">6.1 描述 ......................................................................................................................... 18</div><div class="t m0 x3 h6 y24 ff2 fs3 fc0 sc0 ls8 ws0">6.2 转换连接 ................................................................................................................. 18</div><div class="t m0 x3 h6 y25 ff2 fs3 fc0 sc0 ls8 ws0">6.3 任务连接 ................................................................................................................. 18</div><div class="t m0 x3 h6 y26 ff2 fs3 fc0 sc0 ls8 ws0">6.4 屏幕截图 ................................................................................................................. 18</div><div class="t m0 x3 h6 y27 ff2 fs3 fc0 sc0 ls8 ws0">6.5 创建一个连接 ......................................................................................................... 19</div><div class="t m0 x3 h6 y28 ff2 fs3 fc0 sc0 ls8 ws0">6.6 拆分一个连接 ......................................................................................................... 19</div><div class="t m0 x3 h6 y29 ff2 fs3 fc0 sc0 ls8 ws0">6.7 转换连接颜色 ......................................................................................................... 19</div><div class="t m0 x1 h6 y2a ff2 fs3 fc0 sc0 ls6 ws0">7. 变量（Va ria ble s） .................................................................................................................. 20</div></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div></body></html>

<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9938298/bg2.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">技术资料，【Kette3.0 用户手册】 </div><div class="t m0 x1 h3 y2 ff3 fs0 fc0 sc0 ls0 ws0">©深圳市神盾信息技术有限公司，2008 第 2 页/共 202 页 </div><div class="t m0 x3 h6 y2b ff2 fs3 fc0 sc0 ls8 ws0">7.1 变量使用 ................................................................................................................. 20</div><div class="t m0 x3 h6 y2c ff2 fs3 fc0 sc0 ls8 ws0">7.2 变量范围 ................................................................................................................. 20</div><div class="t m0 x4 h6 y2d ff2 fs3 fc0 sc0 ls8 ws0">7.2.1 环境变量 ......................................................................................................... 20</div><div class="t m0 x4 h6 y2e ff2 fs3 fc0 sc0 ls8 ws0">7.2.2 Kettle 变量 ...................................................................................................... 21</div><div class="t m0 x4 h6 y2f ff2 fs3 fc0 sc0 ls8 ws0">7.2.3 内部变量 ......................................................................................................... 21</div><div class="t m0 x1 h6 y30 ff2 fs3 fc0 sc0 ls6 ws0">8. 转换设置（Transformation Settings） .................................................................................. 22</div><div class="t m0 x3 h6 y31 ff2 fs3 fc0 sc0 ls8 ws0">8.1 描述 ......................................................................................................................... 22</div><div class="t m0 x3 h6 y32 ff2 fs3 fc0 sc0 ls8 ws0">8.2 屏幕截图 ................................................................................................................. 22</div><div class="t m0 x3 h6 y33 ff2 fs3 fc0 sc0 ls8 ws0">8.3 选项 ......................................................................................................................... 25</div><div class="t m0 x3 h6 y34 ff2 fs3 fc0 sc0 ls8 ws0">8.4 其它 ......................................................................................................................... 26</div><div class="t m0 x1 h6 y35 ff2 fs3 fc0 sc0 ls6 ws0">9. 转换步骤（Transformation steps） ....................................................................................... 27</div><div class="t m0 x3 h6 y36 ff2 fs3 fc0 sc0 ls8 ws0">9.1 描述 ......................................................................................................................... 27</div><div class="t m0 x3 h6 y37 ff2 fs3 fc0 sc0 ls8 ws0">9.2 运行步骤的多个副本 ............................................................................................. 27</div><div class="t m0 x3 h6 y38 ff2 fs3 fc0 sc0 ls8 ws0">9.3 分发或者复制 ......................................................................................................... 28</div><div class="t m0 x3 h6 y39 ff2 fs3 fc0 sc0 ls8 ws0">9.4 常用错误处理 ......................................................................................................... 29</div><div class="t m0 x3 h6 y3a ff2 fs3 fc0 sc0 ls8 ws0">9.5 Apache 虚拟文件系统（VFS）支持 .................................................................... 31</div><div class="t m0 x3 h6 y3b ff2 fs3 fc0 sc0 ls8 ws0">9.6 转换步骤类型 ......................................................................................................... 33</div><div class="t m0 x4 h6 y3c ff2 fs3 fc0 sc0 ls8 ws0">9.6.1 文本文件输入（Text Input） ........................................................................ 33</div><div class="t m0 x4 h6 y3d ff2 fs3 fc0 sc0 ls8 ws0">9.6.2</div><div class="t m0 x5 h6 y3e ff6 fs3 fc0 sc0 ls0 ws0"> 表输入（Table Input） ................................................................................... 45</div><div class="t m0 x4 h6 y3f ff2 fs3 fc0 sc0 ls8 ws0">9.6.3 获取系统信息（Get System Info） ............................................................... 47</div><div class="t m0 x4 h6 y40 ff2 fs3 fc0 sc0 ls8 ws0">9.6.4 生成行（Generate Rows） ............................................................................ 51</div><div class="t m0 x4 h6 y41 ff2 fs3 fc0 sc0 ls8 ws0">9.6.5 文件反序列化（De-serialize from file）（原来名称为 Cube 输入） .......... 52</div><div class="t m0 x4 h6 y42 ff2 fs3 fc0 sc0 ls8 ws0">9.6.6 XBase 输入（XBase input） ......................................................................... 53</div><div class="t m0 x4 h6 y43 ff2 fs3 fc0 sc0 ls8 ws0">9.6.7 Excel 输入（Excel Input） ............................................................................ 54</div><div class="t m0 x4 h6 y44 ff2 fs3 fc0 sc0 ls8 ws0">9.6.8 XML 输入(XML input) .................................................................................. 58</div><div class="t m0 x4 h6 y45 ff2 fs3 fc0 sc0 ls8 ws0">9.6.9 获取文件名(Get File Names) ......................................................................... 61</div><div class="t m0 x4 h6 y46 ff2 fs3 fc0 sc0 ls19 ws0">9.6.10 文本文件输出(Text File Output) .................................................................... 62</div><div class="t m0 x4 h6 y47 ff2 fs3 fc0 sc0 ls8 ws0">9.6.11 表输出(Table output) ...................................................................................... 65</div><div class="t m0 x4 h6 y48 ff2 fs3 fc0 sc0 ls19 ws0">9.6.12 插入/更新(Insert/Update) ............................................................................... 68</div><div class="t m0 x4 h6 y49 ff2 fs3 fc0 sc0 ls19 ws0">9.6.13 更新（Update） ............................................................................................. 70</div><div class="t m0 x4 h6 y4a ff2 fs3 fc0 sc0 ls19 ws0">9.6.14 删除(Delete) .................................................................................................... 71</div><div class="t m0 x4 h6 y4b ff2 fs3 fc0 sc0 ls19 ws0">9.6.15 序列化到文件(Serialize to file)(以前是 Cube Output) .................................. 72</div><div class="t m0 x4 h6 y4c ff2 fs3 fc0 sc0 ls19 ws0">9.6.16 XML 输出（XML output） ........................................................................... 73</div><div class="t m0 x4 h6 y4d ff2 fs3 fc0 sc0 ls19 ws0">9.6.17 Excel 输出(Excel Output) ............................................................................... 76</div><div class="t m0 x4 h6 y4e ff2 fs3 fc0 sc0 ls19 ws0">9.6.18 Access 输出（Microsoft Access Output） ..................................................... 78</div><div class="t m0 x4 h6 y4f ff2 fs3 fc0 sc0 ls19 ws0">9.6.19 数据库查询(Database lookup) ....................................................................... 80</div><div class="t m0 x4 h6 y50 ff2 fs3 fc0 sc0 ls19 ws0">9.6.20 流查询（Stream lookup） ............................................................................. 81</div><div class="t m0 x4 h6 y51 ff2 fs3 fc0 sc0 ls19 ws0">9.6.21 调用数据库存储过程(Call DB Procedure) .................................................... 83</div><div class="t m0 x4 h6 y52 ff2 fs3 fc0 sc0 ls19 ws0">9.6.22 HTTP 客户端(HTTP Cient) ............................................................................ 84</div><div class="t m0 x4 h6 y53 ff2 fs3 fc0 sc0 ls19 ws0">9.6.23 字段选择 (Select values) ............................................................................... 86</div><div class="t m0 x4 h6 y54 ff2 fs3 fc0 sc0 ls19 ws0">9.6.24 过滤记录(Filter rows) ..................................................................................... 89</div><div class="t m0 x4 h6 y55 ff2 fs3 fc0 sc0 ls19 ws0">9.6.25 排序记录（Sort rows） ................................................................................. 90</div><div class="t m0 x4 h6 y56 ff2 fs3 fc0 sc0 ls19 ws0">9.6.26 添加序列(Add sequence) ................................................................................ 91</div><div class="t m0 x4 h6 y57 ff2 fs3 fc0 sc0 ls19 ws0">9.6.27 空操作-什么都不做(Dummy-do nothing) ..................................................... 93</div></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9938298/bg3.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">技术资料，【Kette3.0 用户手册】 </div><div class="t m0 x1 h3 y2 ff3 fs0 fc0 sc0 ls0 ws0">©深圳市神盾信息技术有限公司，2008 第 3 页/共 202 页 </div><div class="t m0 x4 h6 y2b ff2 fs3 fc0 sc0 ls19 ws0">9.6.28 行转列(Row Normaliser) ................................................................................ 95</div><div class="t m0 x4 h6 y2c ff2 fs3 fc0 sc0 ls19 ws0">9.6.29 拆分字段（Split Fields）............................................................................... 97</div><div class="t m0 x4 h6 y2d ff2 fs3 fc0 sc0 ls19 ws0">9.6.30 去除重复记录(Unique rows) .......................................................................... 98</div><div class="t m0 x4 h6 y2e ff2 fs3 fc0 sc0 ls19 ws0">9.6.31 分组(Group By) ............................................................................................ 100</div><div class="t m0 x4 h6 y2f ff2 fs3 fc0 sc0 ls19 ws0">9.6.32 设置为空值(Null if) ...................................................................................... 101</div><div class="t m0 x4 h6 y30 ff2 fs3 fc0 sc0 ls19 ws0">9.6.33 计算器（Calculator） .................................................................................. 102</div><div class="t m0 x4 h6 y31 ff2 fs3 fc0 sc0 ls19 ws0">9.6.34 增加 XML（XML Add） ............................................................................. 104</div><div class="t m0 x4 h6 y32 ff2 fs3 fc0 sc0 ls19 ws0">9.6.35 增加常量（Add constants） ........................................................................ 106</div><div class="t m0 x4 h6 y33 ff2 fs3 fc0 sc0 ls19 ws0">9.6.36 行转列（Row Denormaliser） ..................................................................... 107</div><div class="t m0 x4 h6 y34 ff2 fs3 fc0 sc0 ls19 ws0">9.6.37 行扁平化（Flattener） ................................................................................. 108</div><div class="t m0 x4 h6 y35 ff2 fs3 fc0 sc0 ls19 ws0">9.6.38 值映射（Value Mapper） ............................................................................ 110</div><div class="t m0 x4 h6 y36 ff2 fs3 fc0 sc0 ls19 ws0">9.6.39 被冻结的步骤（Blocking step） ................................................................. 111</div><div class="t m0 x4 h6 y37 ff2 fs3 fc0 sc0 ls19 ws0">9.6.40 记录关联（笛卡尔输出）（Join Rows-Cartesian Product）....................... 112</div><div class="t m0 x4 h6 y38 ff2 fs3 fc0 sc0 ls19 ws0">9.6.41 数据库连接（Database Join） ..................................................................... 114</div><div class="t m0 x4 h6 y39 ff2 fs3 fc0 sc0 ls19 ws0">9.6.42 合并记录（Merge rows） ............................................................................ 115</div><div class="t m0 x4 h6 y3a ff2 fs3 fc0 sc0 ls19 ws0">9.6.43</div><div class="t m0 x6 h6 y58 ff6 fs3 fc0 sc0 ls0 ws0"> 存储合并（Stored Merge） ......................................................................... 116</div><div class="t m0 x4 h6 y59 ff2 fs3 fc0 sc0 ls19 ws0">9.6.44 合并连接(Merge Join) .................................................................................. 117</div><div class="t m0 x4 h6 y5a ff2 fs3 fc0 sc0 ls19 ws0">9.6.45 Java Script 值（Java Script Value） ............................................................. 119</div><div class="t m0 x4 h6 y5b ff2 fs3 fc0 sc0 ls19 ws0">9.6.46 改进的 Java Script 值（Modified Java Script Value） ................................ 127</div><div class="t m0 x4 h6 y5c ff2 fs3 fc0 sc0 ls19 ws0">9.6.47 执行 SQL 语句（Execute SQL script） ...................................................... 129</div><div class="t m0 x4 h6 y5d ff2 fs3 fc0 sc0 ls19 ws0">9.6.48 维度更新/查询（Dimension lookup/update） ............................................ 132</div><div class="t m0 x4 h6 y5e ff2 fs3 fc0 sc0 ls19 ws0">9.6.49 联合更新/查询（Combination lookup/update） ......................................... 133</div><div class="t m0 x4 h6 y5f ff2 fs3 fc0 sc0 ls19 ws0">9.6.50 映射（Mapping） ........................................................................................ 134</div><div class="t m0 x4 h6 y60 ff2 fs3 fc0 sc0 ls19 ws0">9.6.51 从结果获取记录（Get rows from result） .................................................. 135</div><div class="t m0 x4 h6 y61 ff2 fs3 fc0 sc0 ls19 ws0">9.6.52 复制记录到结果（Copy rows to result） .................................................... 135</div><div class="t m0 x4 h6 y62 ff2 fs3 fc0 sc0 ls19 ws0">9.6.53 设置变量（Set Variable） ........................................................................... 136</div><div class="t m0 x4 h6 y63 ff2 fs3 fc0 sc0 ls19 ws0">9.6.54 获取变量（Get Variable） ........................................................................... 137</div><div class="t m0 x4 h6 y64 ff2 fs3 fc0 sc0 ls19 ws0">9.6.55 从以前的结果获取文件（Get files from result） ....................................... 138</div><div class="t m0 x4 h6 y65 ff2 fs3 fc0 sc0 ls19 ws0">9.6.56 复制文件名到结果（Set files in result</div><div class="t m0 x7 h6 y66 ff1 fs3 fc0 sc0 ls0 ws0">） .................................................... 139</div><div class="t m0 x4 h6 y67 ff2 fs3 fc0 sc0 ls19 ws0">9.6.57 记录注射器（Injector） .............................................................................. 140</div><div class="t m0 x4 h6 y68 ff2 fs3 fc0 sc0 ls19 ws0">9.6.58 套接字读入器（Socket Reader） ................................................................ 141</div><div class="t m0 x4 h6 y69 ff2 fs3 fc0 sc0 ls19 ws0">9.6.59 套接字输写器（Socket Writer） ................................................................. 141</div><div class="t m0 x4 h6 y6a ff2 fs3 fc0 sc0 ls19 ws0">9.6.60 聚合行（Aggregate Rows） ........................................................................ 142</div><div class="t m0 x4 h6 y6b ff2 fs3 fc0 sc0 ls19 ws0">9.6.61 流 XML 输入（Streaming XML Input） .................................................. 143</div><div class="t m0 x4 h6 y6c ff2 fs3 fc0 sc0 ls19 ws0">9.6.62 中止（Abort） ............................................................................................. 149</div><div class="t m0 x4 h6 y6d ff2 fs3 fc0 sc0 ls19 ws0">9.6.63 Oracle 批量装载（Oracle bulk loader） ...................................................... 151</div><div class="t m0 x1 h6 y6e ff2 fs3 fc0 sc0 ls6 ws0">10. 任务设置（Job Settings） ........................................................................................... 153</div><div class="t m0 x3 h6 y6f ff2 fs3 fc0 sc0 ls6 ws0">10.1 描述 ....................................................................................................................... 153</div><div class="t m0 x3 h6 y70 ff2 fs3 fc0 sc0 ls6 ws0">10.2 屏幕截图 ............................................................................................................... 153</div><div class="t m0 x3 h6 y71 ff2 fs3 fc0 sc0 ls6 ws0">10.3 选项 ....................................................................................................................... 153</div><div class="t m0 x3 h6 y72 ff2 fs3 fc0 sc0 ls6 ws0">10.4 其它 ....................................................................................................................... 154</div><div class="t m0 x1 h6 y73 ff2 fs3 fc0 sc0 ls2a ws0">11. 任务条目（Job Entries） ............................................................................................. 154</div><div class="t m0 x3 h6 y74 ff2 fs3 fc0 sc0 ls2a ws0">11.1 描述 ....................................................................................................................... 154</div><div class="t m0 x3 h6 y75 ff2 fs3 fc0 sc0 ls2a ws0">11.2 任务条目类型 ....................................................................................................... 155</div></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9938298/bg4.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">技术资料，【Kette3.0 用户手册】 </div><div class="t m0 x1 h3 y2 ff3 fs0 fc0 sc0 ls0 ws0">©深圳市神盾信息技术有限公司，2008 第 4 页/共 202 页 </div><div class="t m0 x4 h6 y2b ff2 fs3 fc0 sc0 lsf ws0">11.2.1 特殊的任务条目 ........................................................................................... 155</div><div class="t m0 x4 h6 y2c ff2 fs3 fc0 sc0 lsf ws0">11.2.2 转换 ............................................................................................................... 157</div><div class="t m0 x4 h6 y2d ff2 fs3 fc0 sc0 lsf ws0">11.2.3 任务 ............................................................................................................... 159</div><div class="t m0 x4 h6 y2e ff2 fs3 fc0 sc0 lsf ws0">11.2.4 Shell .............................................................................................................. 161</div><div class="t m0 x4 h6 y2f ff2 fs3 fc0 sc0 lsf ws0">11.2.5 Mail ............................................................................................................... 163</div><div class="t m0 x4 h6 y30 ff2 fs3 fc0 sc0 lsf ws0">11.2.6 SQL ............................................................................................................... 165</div><div class="t m0 x4 h6 y31 ff2 fs3 fc0 sc0 lsf ws0">11.2.7 FTP ................................................................................................................ 166</div><div class="t m0 x4 h6 y32 ff2 fs3 fc0 sc0 lsf ws0">11.2.8 Table Exists ................................................................................................... 168</div><div class="t m0 x4 h6 y33 ff2 fs3 fc0 sc0 lsf ws0">11.2.9 File Exists ...................................................................................................... 169</div><div class="t m0 x4 h6 y34 ff2 fs3 fc0 sc0 ls2b ws0">11.2.10 Evaluation(javascript) ................................................................................... 170</div><div class="t m0 x4 h6 y35 ff2 fs3 fc0 sc0 ls2a ws0">11.2.11 SFTP .............................................................................................................. 171</div><div class="t m0 x4 h6 y36 ff2 fs3 fc0 sc0 ls2b ws0">11.2.12 HTTP ............................................................................................................. 173</div><div class="t m0 x4 h6 y37 ff2 fs3 fc0 sc0 ls2b ws0">11.2.13 Create file ...................................................................................................... 175</div><div class="t m0 x4 h6 y38 ff2 fs3 fc0 sc0 ls2b ws0">11.2.14 Delete file ...................................................................................................... 176</div><div class="t m0 x4 h6 y39 ff2 fs3 fc0 sc0 ls2b ws0">11.2.15 Wait for file ................................................................................................... 177</div><div class="t m0 x4 h6 y3a ff2 fs3 fc0 sc0 ls2b ws0">11.2.16 File compare .................................................................................................. 178</div><div class="t m0 x4 h6 y3b ff2 fs3 fc0 sc0 ls2b ws0">11.2.17 Put files with secureFTP ............................................................................... 180</div><div class="t m0 x4 h6 y3c ff2 fs3 fc0 sc0 ls2b ws0">11.2.18 Ping a host ..................................................................................................... 181</div><div class="t m0 x4 h6 y3d ff2 fs3 fc0 sc0 ls2b ws0">11.2.19 Wait for .......................................................................................................... 182</div><div class="t m0 x4 h6 y76 ff2 fs3 fc0 sc0 ls2b ws0">11.2.20 Display Msgbox info ..................................................................................... 183</div><div class="t m0 x4 h6 y77 ff2 fs3 fc0 sc0 ls2b ws0">11.2.21 Abort job ....................................................................................................... 184</div><div class="t m0 x4 h6 y78 ff2 fs3 fc0 sc0 ls2b ws0">11.2.22 XSL transformation ....................................................................................... 185</div><div class="t m0 x4 h6 y79 ff2 fs3 fc0 sc0 ls2b ws0">11.2.23 Zip files ......................................................................................................... 186</div><div class="t m0 x1 h6 y7a ff2 fs3 fc0 sc0 ls6 ws0">12. 图形界面（Graphical View）</div><div class="t m0 x8 h6 y7b ff2 fs3 fc0 sc0 ls5 wse"> ...................................................................................... 187</div><div class="t m0 x3 h6 y7c ff2 fs3 fc0 sc0 ls6 ws0">12.1 描述 ....................................................................................................................... 187</div><div class="t m0 x3 h6 y7d ff2 fs3 fc0 sc0 ls6 ws0">12.2 添加步骤或者任务条目 ....................................................................................... 188</div><div class="t m0 x4 h6 y7e ff2 fs3 fc0 sc0 ls6 ws0">12.2.1 拖放创建步骤 ............................................................................................... 188</div><div class="t m0 x4 h6 y7f ff2 fs3 fc0 sc0 ls6 ws0">12.2.2 从步骤类型树创建步骤 ............................................................................... 188</div><div class="t m0 x4 h6 y80 ff2 fs3 fc0 sc0 ls6 ws0">12.2.3 在你想要的位置创建步骤 ........................................................................... 189</div><div class="t m0 x3 h6 y81 ff2 fs3 fc0 sc0 ls6 ws0">12.3 隐藏步骤 ............................................................................................................... 189</div><div class="t m0 x3 h6 y82 ff2 fs3 fc0 sc0 ls6 ws0">12.4 转换步骤选项（右键上下文菜单） ................................................................... 189</div><div class="t m0 x4 h6 y83 ff2 fs3 fc0 sc0 ls6 ws0">12.4.1 编辑步骤 ....................................................................................................... 189</div><div class="t m0 x4 h6 y84 ff2 fs3 fc0 sc0 ls6 ws0">12.4.2 编辑步骤描述 ............................................................................................... 189</div><div class="t m0 x4 h6 y85 ff2 fs3 fc0 sc0 ls6 ws0">12.4.3 数据迁移 ....................................................................................................... 189</div><div class="t m0 x4 h6 y86 ff2 fs3 fc0 sc0 ls6 ws0">12.4.4 复制 ............................................................................................................... 189</div><div class="t m0 x4 h6 y87 ff2 fs3 fc0 sc0 ls6 ws0">12.4.5 复制步骤 ....................................................................................................... 189</div><div class="t m0 x4 h6 y88 ff2 fs3 fc0 sc0 ls6 ws0">12.4.6 删除步骤 ....................................................................................................... 190</div><div class="t m0 x4 h6 y89 ff2 fs3 fc0 sc0 ls6 ws0">12.4.7 显示输入字段 ............................................................................................... 190</div><div class="t m0 x4 h6 y8a ff2 fs3 fc0 sc0 ls6 ws0">12.4.8 显示输出字段 ............................................................................................... 190</div><div class="t m0 x3 h6 y8b ff2 fs3 fc0 sc0 ls6 ws0">12.5 任务条目选项（右键上下文菜单） ................................................................... 190</div><div class="t m0 x4 h6 y8c ff2 fs3 fc0 sc0 ls6 ws0">12.5.1 打开转换/任务 .............................................................................................. 190</div><div class="t m0 x4 h6 y8d ff2 fs3 fc0 sc0 ls6 ws0">12.5.2 编辑任务入口 ............................................................................................... 190</div><div class="t m0 x4 h6 y8e ff2 fs3 fc0 sc0 ls6 ws0">12.5.3 编辑任务入口描述 ....................................................................................... 190</div><div class="t m0 x4 h6 y8f ff2 fs3 fc0 sc0 ls6 ws0">12.5.4</div><div class="t m0 x9 h6 y90 ff1 fs3 fc0 sc0 ls0 ws0">复制任务入口 ............................................................................................... 190</div></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/9938298/bg5.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">技术资料，【Kette3.0 用户手册】 </div><div class="t m0 x1 h3 y2 ff3 fs0 fc0 sc0 ls0 ws0">©深圳市神盾信息技术有限公司，2008 第 5 页/共 202 页 </div><div class="t m0 x4 h6 y2b ff2 fs3 fc0 sc0 ls6 ws0">12.5.5 复制选择的任务入口到剪贴板 ................................................................... 190</div><div class="t m0 x4 h6 y2c ff2 fs3 fc0 sc0 ls6 ws0">12.5.6 排列/分布 ...................................................................................................... 191</div><div class="t m0 x4 h6 y2d ff2 fs3 fc0 sc0 ls6 ws0">12.5.7 拆开节点 ....................................................................................................... 191</div><div class="t m0 x4 h6 y2e ff2 fs3 fc0 sc0 ls6 ws0">12.5.8 删除所有任务入口的副本 ........................................................................... 191</div><div class="t m0 x3 h6 y2f ff2 fs3 fc0 sc0 ls6 ws0">12.6 添加节点连接 ....................................................................................................... 191</div><div class="t m0 x3 h6 y30 ff2 fs3 fc0 sc0 ls6 ws0">12.7 运行转换 ............................................................................................................... 191</div><div class="t m0 x3 h6 y31 ff2 fs3 fc0 sc0 ls6 ws0">12.8 屏幕截图 ............................................................................................................... 191</div><div class="t m0 x3 h6 y32 ff2 fs3 fc0 sc0 ls6 ws0">12.9 执行选项 ............................................................................................................... 192</div><div class="t m0 x4 h6 y33 ff2 fs3 fc0 sc0 ls6 ws0">12.9.1 在哪里执行 ................................................................................................... 192</div><div class="t m0 x4 h6 y34 ff2 fs3 fc0 sc0 ls6 ws0">12.9.2 预览 ............................................................................................................... 192</div><div class="t m0 x4 h6 y35 ff2 fs3 fc0 sc0 ls6 ws0">12.9.3 使用安全模式 ............................................................................................... 192</div><div class="t m0 x4 h6 y36 ff2 fs3 fc0 sc0 ls6 ws0">12.9.4 日志级别 ....................................................................................................... 192</div><div class="t m0 x4 h6 y37 ff2 fs3 fc0 sc0 ls6 ws0">12.9.5 重放日期 ....................................................................................................... 192</div><div class="t m0 x4 h6 y38 ff2 fs3 fc0 sc0 ls6 ws0">12.9.6 参数 ............................................................................................................... 192</div><div class="t m0 x4 h6 y39 ff2 fs3 fc0 sc0 ls6 ws0">12.9.7 变量 ............................................................................................................... 192</div><div class="t m0 x3 h6 y3a ff2 fs3 fc0 sc0 ls6 ws0">12.10 设置远程或者从属服务器 ................................................................................... 193</div><div class="t m0 x4 h6 y3b ff2 fs3 fc0 sc0 ls25 ws0">12.10.1 概述 ....................................................................................................... 193</div><div class="t m0 x4 h6 y3c ff2 fs3 fc0 sc0 ls25 ws0">12.10.2 屏幕截图 ............................................................................................... 193</div><div class="t m0 x1 h6 y3d ff2 fs3 fc0 sc0 ls6 ws0">13. 日志（Logging） ......................................................................................................... 193</div><div class="t m0 x3 h6 y76 ff2 fs3 fc0 sc0 ls6 ws0">13.1</div><div class="t m0 x5 h6 y91 ff1 fs3 fc0 sc0 ls0 ws0">日志描述 ............................................................................................................... 193</div><div class="t m0 x3 h6 y92 ff2 fs3 fc0 sc0 ls6 ws0">13.2 屏幕截图 ............................................................................................................... 194</div><div class="t m0 x3 h6 y93 ff2 fs3 fc0 sc0 ls6 ws0">13.3 日志网格 ............................................................................................................... 194</div><div class="t m0 x4 h6 y94 ff2 fs3 fc0 sc0 ls6 ws0">13.3.1 转换日志网格 ............................................................................................... 194</div><div class="t m0 x4 h6 y95 ff2 fs3 fc0 sc0 ls6 ws0">13.3.2 任务日志网格 ............................................................................................... 195</div><div class="t m0 x3 h6 y96 ff2 fs3 fc0 sc0 ls6 ws0">13.4 按钮 ....................................................................................................................... 195</div><div class="t m0 x4 h6 y97 ff2 fs3 fc0 sc0 ls6 ws0">13.4.1 转换按钮 ....................................................................................................... 195</div><div class="t m0 x4 h6 y98 ff2 fs3 fc0 sc0 ls6 ws0">13.4.2 任务按钮 ....................................................................................................... 197</div><div class="t m0 x1 h6 y99 ff2 fs3 fc0 sc0 ls6 ws0">14. 网格（Grids） .............................................................................................................. 198</div><div class="t m0 x3 h6 y9a ff2 fs3 fc0 sc0 ls6 ws0">14.1 描述 ....................................................................................................................... 198</div><div class="t m0 x3 h6 y9b ff2 fs3 fc0 sc0 ls6 ws0">14.2 功能 ....................................................................................................................... 198</div><div class="t m0 x3 h6 y9c ff2 fs3 fc0 sc0 ls6 ws0">14.3 导航 ....................................................................................................................... 199</div><div class="t m0 x1 h6 y9d ff2 fs3 fc0 sc0 ls6 ws0">15. 资源库浏览器（Repository Explorer） ...................................................................... 199</div><div class="t m0 x3 h6 y9e ff2 fs3 fc0 sc0 ls6 ws0">15.1 描述 ....................................................................................................................... 199</div><div class="t m0 x3 h6 y9f ff2 fs3 fc0 sc0 ls6 ws0">15.2 屏幕截图 ............................................................................................................... 200</div><div class="t m0 x3 h6 ya0 ff2 fs3 fc0 sc0 ls6 ws0">15.3 右键单击功能 ....................................................................................................... 200</div><div class="t m0 x3 h6 ya1 ff2 fs3 fc0 sc0 ls6 ws0">15.4 备份/资源库 .......................................................................................................... 200</div><div class="t m0 x1 h6 ya2 ff2 fs3 fc0 sc0 ls6 ws0">16. 共享对象（Share objects） ......................................................................................... 201</div><div class="t m0 x1 h6 ya3 ff2 fs3 fc0 sc0 ls0 ws0"> </div><div class="t m0 xa h4 ya4 ff1 fs1 fc0 sc1 ls0 ws0"> </div></div><div class="pi" data-data='{"ctm":[1.611639,0.000000,0.000000,1.611639,0.000000,0.000000]}'></div></div>

评论收藏举报

guangri

2019-11-22

还可以，多谢共享
小龙卷卷风

2019-10-10

不错，学习了
LzbcitL

2018-07-10

资源有点老，不过大概看了一下，还是比较详细的
苏晓光

2018-06-15

一共23页，里面有ETL的介绍。还有图形来讲解，还不错的简单入门。
一只小菜鸡

2018-05-31

下了好多次没有下载成功

前往

页

天空~华

粉丝: 63
资源:
21

看过该资源的人还看了

精品专辑

内容简介：Kettle学习资料大全.zip Kettle学习资料大全 Kettle学习资料大全 Kettle相关内容及实验（周博翔）.doc KETTLE.pdf pentaho-kettle_4.2.1基础教程.doc kettle各个组件用法.doc ETL工具KETTLE实例手册.pdf 数据库原理及应用（SQL+Server版）（2012最新版）.pdf ETL工具Kettle用户手册.pdf kettle入门例子大全.doc Kettle培训手册.pdf

Kettle从入门到精通文档

KETTLE从入门到精通

遇见Kettle ETL工具课程入门-进阶-实战 Kettle2020全新从入门到精通实战课程

kettle入门与实战视频教程（6-9）

kettle入门与实战(1~5节)

kettle入门与实战 第2节

Kettle的基础入门文档

kettle实战教程.pdf

Kettle初级教程(入门级详细解析各个控件)

kettle 入门与提高

Kettle8.2入门PPT.rar

史上最强Kettle培训教程.pdf

Kettle学习 简明教程.pdf

kettle数据迁移操作文档

kettle学习,word格式的文档，有目录，条理清晰

kettle 开发视频文档

kettle学习和使用文档

kettle帮助文档

kettle基础文档

kettle 7.1 官方例子(附带文档整理-中英文对照)

kettle 7.1 使用文档(初级)

BI Kettle文档汇集.rar

BI Kettle中文文档汇集

Kettle中文文档.zip

1.Kettle （Spoon） 教程 中文详解 pdf

kettle_7.1_api文档.rar

遇见Kettle ETL工具课程入门-进阶-实战 遇见kettle etl工具.zip

Kettle重要学习资料大全

kettle学习

史上最强-Kettle-培训教程

kettle从新手到高手指南

kettle入门与实战第2节

Kettle学习简明教程.pdf

1.Kettle （Spoon）教程中文详解 pdf

遇见Kettle ETL工具课程入门-进阶-实战遇见kettle etl工具.zip