Pentaho-Data-Integration-完全自學(xué)手冊.2022.12.11

1、Pentaho Data Integration 完全自學(xué)手冊 孟菲斯著文檔目錄 TOC o h z u HYPERLINK l _Toc469212557 文檔目錄 PAGEREF _Toc469212557 h 2 HYPERLINK l _Toc469212558 更新記錄 PAGEREF _Toc469212558 h 17 HYPERLINK l _Toc469212559 第一章.Kettle 根底介紹 PAGEREF _Toc469212559 h 18 HYPERLINK l _Toc469212560 1.1.核心組件 PAGEREF _Toc469212560 h 18 H

2、YPERLINK l _Toc469212561 1.2.組成局部 PAGEREF _Toc469212561 h 18 HYPERLINK l _Toc469212562 1.3.概念模型 PAGEREF _Toc469212562 h 19 HYPERLINK l _Toc469212563 1.3.1.Transformation轉(zhuǎn)換 PAGEREF _Toc469212563 h 19 HYPERLINK l _Toc469212564 1.3.2.Steps步驟 PAGEREF _Toc469212564 h 20 HYPERLINK l _Toc469212565 1.3.3.Ho

3、ps節(jié)點(diǎn)連接 PAGEREF _Toc469212565 h 20 HYPERLINK l _Toc469212566 1.3.4.Jobs工作 PAGEREF _Toc469212566 h 20 HYPERLINK l _Toc469212567 1.3.5.Variable變量 PAGEREF _Toc469212567 h 21 HYPERLINK l _Toc469212568 .設(shè)置環(huán)境變量 PAGEREF _Toc469212568 h 21 HYPERLINK l _Toc469212569 .設(shè)置變量 PAGEREF _Toc469212569 h 21 HYPERLINK

4、l _Toc469212570 1.4.查看版本 PAGEREF _Toc469212570 h 22 HYPERLINK l _Toc469212571 1.5.選項(xiàng)設(shè)置 PAGEREF _Toc469212571 h 23 HYPERLINK l _Toc469212572 第二章.Kettle 環(huán)境搭建 PAGEREF _Toc469212572 h 25 HYPERLINK l _Toc469212573 2.1.單機(jī)部署 PAGEREF _Toc469212573 h 25 HYPERLINK l _Toc469212574 2.1.1.下載kettle PAGEREF _Toc46

5、9212574 h 25 HYPERLINK l _Toc469212575 2.1.2.安裝kettle PAGEREF _Toc469212575 h 25 HYPERLINK l _Toc469212576 2.1.3.運(yùn)行Spoon PAGEREF _Toc469212576 h 25 HYPERLINK l _Toc469212577 2.2.集群部署 PAGEREF _Toc469212577 h 26 HYPERLINK l _Toc469212578 1. Carte簡介 PAGEREF _Toc469212578 h 26 HYPERLINK l _Toc469212579

6、2. Carte部署配置 PAGEREF _Toc469212579 h 26 HYPERLINK l _Toc469212580 2.1 啟動方法 PAGEREF _Toc469212580 h 26 HYPERLINK l _Toc469212581 2.2 啟動配置 PAGEREF _Toc469212581 h 26 HYPERLINK l _Toc469212582 2.3 Carte xml文件配置詳解 PAGEREF _Toc469212582 h 27 HYPERLINK l _Toc469212583 2.3.1 slaveserver節(jié)點(diǎn) PAGEREF _Toc46921

7、2583 h 28 HYPERLINK l _Toc469212584 2.3.2 masters節(jié)點(diǎn) PAGEREF _Toc469212584 h 28 HYPERLINK l _Toc469212585 2.3.3 report_to_masters節(jié)點(diǎn) PAGEREF _Toc469212585 h 28 HYPERLINK l _Toc469212586 2.3.4 max_log_lines節(jié)點(diǎn) PAGEREF _Toc469212586 h 28 HYPERLINK l _Toc469212587 2.3.5 max_log_timeout_minutes節(jié)點(diǎn) PAGEREF _

8、Toc469212587 h 28 HYPERLINK l _Toc469212588 2.3.6 object_timeout_minutes節(jié)點(diǎn) PAGEREF _Toc469212588 h 29 HYPERLINK l _Toc469212589 2.3.7 (*) repository節(jié)點(diǎn) PAGEREF _Toc469212589 h 29 HYPERLINK l _Toc469212590 3. Carte集群 PAGEREF _Toc469212590 h 29 HYPERLINK l _Toc469212591 3.1 普通集群 PAGEREF _Toc469212591 h

9、 30 HYPERLINK l _Toc469212592 3.2 動態(tài)集群 PAGEREF _Toc469212592 h 30 HYPERLINK l _Toc469212593 2.3.運(yùn)行方式 PAGEREF _Toc469212593 h 30 HYPERLINK l _Toc469212594 2.3.1.轉(zhuǎn)換執(zhí)行器 Pan PAGEREF _Toc469212594 h 30 HYPERLINK l _Toc469212595 .Pan 參數(shù)介紹 PAGEREF _Toc469212595 h 30 HYPERLINK l _Toc469212596 .Pan 實(shí)例講解：Wind

10、ows PAGEREF _Toc469212596 h 31 HYPERLINK l _Toc469212597 .Pan 實(shí)例講解：Linux PAGEREF _Toc469212597 h 31 HYPERLINK l _Toc469212598 2.3.2.任務(wù)執(zhí)行器 Kitchen PAGEREF _Toc469212598 h 32 HYPERLINK l _Toc469212599 .Kitchen 參數(shù)介紹 PAGEREF _Toc469212599 h 32 HYPERLINK l _Toc469212600 .Kitchen 實(shí)例講解：Windows PAGEREF _Toc

11、469212600 h 33 HYPERLINK l _Toc469212601 .Kitchen 實(shí)例講解：Linux PAGEREF _Toc469212601 h 34 HYPERLINK l _Toc469212602 2.4.定時任務(wù) PAGEREF _Toc469212602 h 35 HYPERLINK l _Toc469212603 2.4.1.Windows PAGEREF _Toc469212603 h 35 HYPERLINK l _Toc469212604 2.4.2.Linux PAGEREF _Toc469212604 h 35 HYPERLINK l _Toc46

12、9212605 第三章.Kettle 根本功能 PAGEREF _Toc469212605 h 36 HYPERLINK l _Toc469212606 3.1.新建轉(zhuǎn)換 PAGEREF _Toc469212606 h 36 HYPERLINK l _Toc469212607 3.1.1.方法1 PAGEREF _Toc469212607 h 36 HYPERLINK l _Toc469212608 3.1.2.方法2 PAGEREF _Toc469212608 h 36 HYPERLINK l _Toc469212609 3.1.3.方法3 PAGEREF _Toc469212609 h 3

13、7 HYPERLINK l _Toc469212610 3.1.4.主對象樹 PAGEREF _Toc469212610 h 37 HYPERLINK l _Toc469212611 3.1.5.核心對象 PAGEREF _Toc469212611 h 38 HYPERLINK l _Toc469212612 3.1.6.新建數(shù)據(jù)庫連接 PAGEREF _Toc469212612 h 38 HYPERLINK l _Toc469212613 3.2.轉(zhuǎn)換實(shí)例 PAGEREF _Toc469212613 h 39 HYPERLINK l _Toc469212614 3.2.1.轉(zhuǎn)換實(shí)例1 PAG

14、EREF _Toc469212614 h 39 HYPERLINK l _Toc469212615 3.2.2.轉(zhuǎn)換實(shí)例2 PAGEREF _Toc469212615 h 39 HYPERLINK l _Toc469212616 3.3.新建作業(yè) PAGEREF _Toc469212616 h 40 HYPERLINK l _Toc469212617 3.3.1.方法1 PAGEREF _Toc469212617 h 40 HYPERLINK l _Toc469212618 3.3.2.方法2 PAGEREF _Toc469212618 h 40 HYPERLINK l _Toc4692126

15、19 3.3.3.方法3 PAGEREF _Toc469212619 h 41 HYPERLINK l _Toc469212620 3.3.4.主對象樹 PAGEREF _Toc469212620 h 41 HYPERLINK l _Toc469212621 3.3.5.核心對象 PAGEREF _Toc469212621 h 42 HYPERLINK l _Toc469212622 3.4.作業(yè)實(shí)例 PAGEREF _Toc469212622 h 42 HYPERLINK l _Toc469212623 3.4.1.作業(yè)實(shí)例1 PAGEREF _Toc469212623 h 42 HYPER

16、LINK l _Toc469212624 3.4.2.作業(yè)實(shí)例2 PAGEREF _Toc469212624 h 42 HYPERLINK l _Toc469212625 第四章.Kettle 設(shè)計環(huán)境 PAGEREF _Toc469212625 h 42 HYPERLINK l _Toc469212626 4.1.Transformation：轉(zhuǎn)換步驟(24-228) PAGEREF _Toc469212626 h 42 HYPERLINK l _Toc469212627 4.1.1.Input：輸入(38) PAGEREF _Toc469212627 h 42 HYPERLINK l _T

17、oc469212628 .Csv file input PAGEREF _Toc469212628 h 42 HYPERLINK l _Toc469212629 .1.功能描述 PAGEREF _Toc469212629 h 43 HYPERLINK l _Toc469212630 .2.操作步驟 PAGEREF _Toc469212630 h 43 HYPERLINK l _Toc469212631 .3.實(shí)例講解 PAGEREF _Toc469212631 h 44 HYPERLINK l _Toc469212632 .DataGrid PAGEREF _Toc469212632 h 44

18、 HYPERLINK l _Toc469212633 .De-serialize from file：文件反序列化 PAGEREF _Toc469212633 h 44 HYPERLINK l _Toc469212634 .ESRI Shapefile Reader PAGEREF _Toc469212634 h 44 HYPERLINK l _Toc469212635 .Email messages input PAGEREF _Toc469212635 h 44 HYPERLINK l _Toc469212636 .Fixed file input PAGEREF _Toc46921263

19、6 h 44 HYPERLINK l _Toc469212637 .GZIP CSV Input PAGEREF _Toc469212637 h 44 HYPERLINK l _Toc469212638 .Generate Rows PAGEREF _Toc469212638 h 44 HYPERLINK l _Toc469212639 .Generate random credit card numbers PAGEREF _Toc469212639 h 44 HYPERLINK l _Toc469212640 0.Generate random value PAGEREF _Toc4692

20、12640 h 45 HYPERLINK l _Toc469212641 1.Get File Names PAGEREF _Toc469212641 h 45 HYPERLINK l _Toc469212642 2.Get Files Rows Count PAGEREF _Toc469212642 h 45 HYPERLINK l _Toc469212643 3.Get SubFolder names PAGEREF _Toc469212643 h 45 HYPERLINK l _Toc469212644 4.Get System Info：獲取系統(tǒng)信息 PAGEREF _Toc46921

21、2644 h 45 HYPERLINK l _Toc469212645 4.1.功能描述 PAGEREF _Toc469212645 h 46 HYPERLINK l _Toc469212646 4.2.操作步驟 PAGEREF _Toc469212646 h 47 HYPERLINK l _Toc469212647 4.3.實(shí)例講解 PAGEREF _Toc469212647 h 48 HYPERLINK l _Toc469212648 5.Get data from XML PAGEREF _Toc469212648 h 49 HYPERLINK l _Toc469212649 6.Get

22、 repository names PAGEREF _Toc469212649 h 49 HYPERLINK l _Toc469212650 7.Get table names PAGEREF _Toc469212650 h 49 HYPERLINK l _Toc469212651 8.Google Analytics PAGEREF _Toc469212651 h 49 HYPERLINK l _Toc469212652 9.HL7 Input PAGEREF _Toc469212652 h 49 HYPERLINK l _Toc469212653 0.JSON Input PAGEREF

23、_Toc469212653 h 49 HYPERLINK l _Toc469212654 1.LDAP Input PAGEREF _Toc469212654 h 49 HYPERLINK l _Toc469212655 2.LDIF Input PAGEREF _Toc469212655 h 50 HYPERLINK l _Toc469212656 3.Load file content in memory PAGEREF _Toc469212656 h 50 HYPERLINK l _Toc469212657 4.Microsoft Access input PAGEREF _Toc469

24、212657 h 50 HYPERLINK l _Toc469212658 5.Microsoft Excel Input PAGEREF _Toc469212658 h 50 HYPERLINK l _Toc469212659 5.1.功能描述 PAGEREF _Toc469212659 h 50 HYPERLINK l _Toc469212660 5.2.操作步驟 PAGEREF _Toc469212660 h 50 HYPERLINK l _Toc469212661 5.2.1.指定文件名 PAGEREF _Toc469212661 h 51 HYPERLINK l _Toc469212

25、662 5.2.2.指定內(nèi)容 PAGEREF _Toc469212662 h 51 HYPERLINK l _Toc469212663 5.2.3.字段 PAGEREF _Toc469212663 h 51 HYPERLINK l _Toc469212664 5.2.4.錯誤處理 PAGEREF _Toc469212664 h 51 HYPERLINK l _Toc469212665 5.2.5.其他輸出字段 PAGEREF _Toc469212665 h 51 HYPERLINK l _Toc469212666 5.3.實(shí)例講解 PAGEREF _Toc469212666 h 51 HYPE

26、RLINK l _Toc469212667 6.Mondrian Input PAGEREF _Toc469212667 h 51 HYPERLINK l _Toc469212668 7.OLAP Input PAGEREF _Toc469212668 h 52 HYPERLINK l _Toc469212669 8.Property Input PAGEREF _Toc469212669 h 52 HYPERLINK l _Toc469212670 9.RSS Input PAGEREF _Toc469212670 h 52 HYPERLINK l _Toc469212671 0.S3 CS

27、V Input PAGEREF _Toc469212671 h 52 HYPERLINK l _Toc469212672 1.SAP Input PAGEREF _Toc469212672 h 52 HYPERLINK l _Toc469212673 2.SAS Input PAGEREF _Toc469212673 h 52 HYPERLINK l _Toc469212674 3.SalesForce Input PAGEREF _Toc469212674 h 52 HYPERLINK l _Toc469212675 4.Table input：表輸入 PAGEREF _Toc4692126

28、75 h 52 HYPERLINK l _Toc469212676 4.1.功能描述 PAGEREF _Toc469212676 h 52 HYPERLINK l _Toc469212677 4.2.操作步驟 PAGEREF _Toc469212677 h 53 HYPERLINK l _Toc469212678 4.3.實(shí)例講解 PAGEREF _Toc469212678 h 54 HYPERLINK l _Toc469212679 5.Text file input：文本文件輸入 PAGEREF _Toc469212679 h 54 HYPERLINK l _Toc469212680 5.

29、1.功能描述 PAGEREF _Toc469212680 h 54 HYPERLINK l _Toc469212681 5.2.操作步驟 PAGEREF _Toc469212681 h 54 HYPERLINK l _Toc469212682 5.2.1.文件名稱指定 PAGEREF _Toc469212682 h 54 HYPERLINK l _Toc469212683 5.2.2.從先前的步驟中接受文件名 PAGEREF _Toc469212683 h 55 HYPERLINK l _Toc469212684 5.2.3.內(nèi)容指定 PAGEREF _Toc469212684 h 55 HY

30、PERLINK l _Toc469212685 5.2.4.錯誤處理 PAGEREF _Toc469212685 h 58 HYPERLINK l _Toc469212686 5.2.5.過濾 PAGEREF _Toc469212686 h 59 HYPERLINK l _Toc469212687 5.2.6.字段 PAGEREF _Toc469212687 h 60 HYPERLINK l _Toc469212688 5.2.7.其他輸出字段 PAGEREF _Toc469212688 h 61 HYPERLINK l _Toc469212689 5.3.格式化 PAGEREF _Toc46

31、9212689 h 61 HYPERLINK l _Toc469212690 5.3.1.Number格式化 PAGEREF _Toc469212690 h 61 HYPERLINK l _Toc469212691 5.3.2.Date格式化 PAGEREF _Toc469212691 h 62 HYPERLINK l _Toc469212692 5.3.3.其它 PAGEREF _Toc469212692 h 63 HYPERLINK l _Toc469212693 5.4.實(shí)例講解 PAGEREF _Toc469212693 h 63 HYPERLINK l _Toc469212694 6

32、.XBase input：XBase輸入 PAGEREF _Toc469212694 h 63 HYPERLINK l _Toc469212695 6.1.功能描述 PAGEREF _Toc469212695 h 63 HYPERLINK l _Toc469212696 7.XML Input Stream(StAX) PAGEREF _Toc469212696 h 64 HYPERLINK l _Toc469212697 7.1.功能描述 PAGEREF _Toc469212697 h 64 HYPERLINK l _Toc469212698 8.Yaml Input PAGEREF _To

33、c469212698 h 65 HYPERLINK l _Toc469212699 4.1.2.Output：輸出(22) PAGEREF _Toc469212699 h 65 HYPERLINK l _Toc469212700 .Automatic Documentation Output PAGEREF _Toc469212700 h 65 HYPERLINK l _Toc469212701 .Delete：刪除 PAGEREF _Toc469212701 h 65 HYPERLINK l _Toc469212702 .1.功能描述 PAGEREF _Toc469212702 h 65 H

34、YPERLINK l _Toc469212703 .2.操作步驟 PAGEREF _Toc469212703 h 65 HYPERLINK l _Toc469212704 .Insert / Update：插入/更新 PAGEREF _Toc469212704 h 66 HYPERLINK l _Toc469212705 .1.功能描述 PAGEREF _Toc469212705 h 66 HYPERLINK l _Toc469212706 .2.操作步驟 PAGEREF _Toc469212706 h 67 HYPERLINK l _Toc469212707 .JSON Output PAG

35、EREF _Toc469212707 h 68 HYPERLINK l _Toc469212708 .LDAP Output PAGEREF _Toc469212708 h 68 HYPERLINK l _Toc469212709 .Mircosoft Access Output PAGEREF _Toc469212709 h 68 HYPERLINK l _Toc469212710 .Mircosoft Excel Output：Excel輸出 PAGEREF _Toc469212710 h 68 HYPERLINK l _Toc469212711 .1.功能描述 PAGEREF _Toc4

36、69212711 h 68 HYPERLINK l _Toc469212712 .2.操作步驟 PAGEREF _Toc469212712 h 68 HYPERLINK l _Toc469212713 .Pentaho Reporting Output PAGEREF _Toc469212713 h 71 HYPERLINK l _Toc469212714 .Properties Output PAGEREF _Toc469212714 h 71 HYPERLINK l _Toc469212715 0.RSS Output PAGEREF _Toc469212715 h 71 HYPERLIN

37、K l _Toc469212716 1.S3 File Output PAGEREF _Toc469212716 h 71 HYPERLINK l _Toc469212717 2.SQL File Output PAGEREF _Toc469212717 h 71 HYPERLINK l _Toc469212718 3.Saleforce Delete PAGEREF _Toc469212718 h 71 HYPERLINK l _Toc469212719 4.Saleforce Insert PAGEREF _Toc469212719 h 71 HYPERLINK l _Toc4692127

38、20 5.Saleforce Update PAGEREF _Toc469212720 h 71 HYPERLINK l _Toc469212721 6.Saleforce Upsert PAGEREF _Toc469212721 h 71 HYPERLINK l _Toc469212722 7.Serialize to file PAGEREF _Toc469212722 h 71 HYPERLINK l _Toc469212723 8.Synchronize after merge PAGEREF _Toc469212723 h 72 HYPERLINK l _Toc469212724 9

39、.Table output PAGEREF _Toc469212724 h 72 HYPERLINK l _Toc469212725 9.1.功能描述 PAGEREF _Toc469212725 h 72 HYPERLINK l _Toc469212726 9.2.操作步驟 PAGEREF _Toc469212726 h 73 HYPERLINK l _Toc469212727 0.Text file output：文本文件輸出 PAGEREF _Toc469212727 h 75 HYPERLINK l _Toc469212728 0.1.功能描述 PAGEREF _Toc469212728

40、 h 75 HYPERLINK l _Toc469212729 0.2.操作步驟 PAGEREF _Toc469212729 h 76 HYPERLINK l _Toc469212730 1.Update：更新 PAGEREF _Toc469212730 h 77 HYPERLINK l _Toc469212731 1.1.功能描述 PAGEREF _Toc469212731 h 77 HYPERLINK l _Toc469212732 1.2.操作步驟 PAGEREF _Toc469212732 h 78 HYPERLINK l _Toc469212733 2.XML Output PAGE

41、REF _Toc469212733 h 79 HYPERLINK l _Toc469212734 4.1.3.Transform：轉(zhuǎn)換(26) PAGEREF _Toc469212734 h 80 HYPERLINK l _Toc469212735 .Add XML PAGEREF _Toc469212735 h 80 HYPERLINK l _Toc469212736 .Add a checksum PAGEREF _Toc469212736 h 80 HYPERLINK l _Toc469212737 .Add constants：增加常量 PAGEREF _Toc469212737 h

42、80 HYPERLINK l _Toc469212738 .1.功能描述 PAGEREF _Toc469212738 h 80 HYPERLINK l _Toc469212739 .2.操作步驟 PAGEREF _Toc469212739 h 80 HYPERLINK l _Toc469212740 .Add sequence PAGEREF _Toc469212740 h 81 HYPERLINK l _Toc469212741 .1.功能描述 PAGEREF _Toc469212741 h 81 HYPERLINK l _Toc469212742 .2.操作步驟 PAGEREF _Toc4

43、69212742 h 81 HYPERLINK l _Toc469212743 .Add value fields changing seqence PAGEREF _Toc469212743 h 82 HYPERLINK l _Toc469212744 .！Calculator：計算器 PAGEREF _Toc469212744 h 82 HYPERLINK l _Toc469212745 .1.功能描述 PAGEREF _Toc469212745 h 83 HYPERLINK l _Toc469212746 .2.操作步驟 PAGEREF _Toc469212746 h 84 HYPERL

44、INK l _Toc469212747 .Closure Generator PAGEREF _Toc469212747 h 85 HYPERLINK l _Toc469212748 .Concat Fields PAGEREF _Toc469212748 h 85 HYPERLINK l _Toc469212749 .Get ID From slave server PAGEREF _Toc469212749 h 85 HYPERLINK l _Toc469212750 0.Number range PAGEREF _Toc469212750 h 85 HYPERLINK l _Toc469

45、212751 1.Replace in string：字符串替換 PAGEREF _Toc469212751 h 85 HYPERLINK l _Toc469212752 1.1.功能描述 PAGEREF _Toc469212752 h 85 HYPERLINK l _Toc469212753 1.2.操作步驟 PAGEREF _Toc469212753 h 85 HYPERLINK l _Toc469212754 2.！Row Normaliser：行轉(zhuǎn)列 PAGEREF _Toc469212754 h 86 HYPERLINK l _Toc469212755 2.1.功能描述 PAGERE

46、F _Toc469212755 h 86 HYPERLINK l _Toc469212756 2.2.操作步驟 PAGEREF _Toc469212756 h 87 HYPERLINK l _Toc469212757 3.Row denormaliser：列轉(zhuǎn)行 PAGEREF _Toc469212757 h 88 HYPERLINK l _Toc469212758 3.1.功能描述 PAGEREF _Toc469212758 h 88 HYPERLINK l _Toc469212759 3.2.操作步驟 PAGEREF _Toc469212759 h 88 HYPERLINK l _Toc4

47、69212760 4.！Row flattener：行扁平化 PAGEREF _Toc469212760 h 88 HYPERLINK l _Toc469212761 4.1.功能描述 PAGEREF _Toc469212761 h 89 HYPERLINK l _Toc469212762 4.2.操作步驟 PAGEREF _Toc469212762 h 89 HYPERLINK l _Toc469212763 5.！Select values：字段選擇 PAGEREF _Toc469212763 h 90 HYPERLINK l _Toc469212764 5.1.功能描述 PAGEREF

48、_Toc469212764 h 90 HYPERLINK l _Toc469212765 5.2.操作步驟 PAGEREF _Toc469212765 h 91 HYPERLINK l _Toc469212766 6.Set field value PAGEREF _Toc469212766 h 92 HYPERLINK l _Toc469212767 7.Set field value to a constant PAGEREF _Toc469212767 h 92 HYPERLINK l _Toc469212768 8.Sort rows PAGEREF _Toc469212768 h 9

49、2 HYPERLINK l _Toc469212769 8.1.功能描述 PAGEREF _Toc469212769 h 92 HYPERLINK l _Toc469212770 8.2.操作步驟 PAGEREF _Toc469212770 h 92 HYPERLINK l _Toc469212771 9.Split Fields:拆分字段 PAGEREF _Toc469212771 h 93 HYPERLINK l _Toc469212772 9.1.功能描述 PAGEREF _Toc469212772 h 93 HYPERLINK l _Toc469212773 9.2.操作步驟 PAGE

50、REF _Toc469212773 h 93 HYPERLINK l _Toc469212774 0.Split Fields to rows PAGEREF _Toc469212774 h 95 HYPERLINK l _Toc469212775 1.String operations PAGEREF _Toc469212775 h 95 HYPERLINK l _Toc469212776 2.String cut：裁剪字符串 PAGEREF _Toc469212776 h 95 HYPERLINK l _Toc469212777 2.1.功能描述 PAGEREF _Toc469212777

51、 h 95 HYPERLINK l _Toc469212778 2.2.操作步驟 PAGEREF _Toc469212778 h 95 HYPERLINK l _Toc469212779 3.Unique rows：去除重復(fù)記錄 PAGEREF _Toc469212779 h 96 HYPERLINK l _Toc469212780 3.1.功能描述 PAGEREF _Toc469212780 h 96 HYPERLINK l _Toc469212781 3.2.操作步驟 PAGEREF _Toc469212781 h 96 HYPERLINK l _Toc469212782 5.！Value

52、 Mapper：值映射 PAGEREF _Toc469212782 h 97 HYPERLINK l _Toc469212783 5.1.功能描述 PAGEREF _Toc469212783 h 97 HYPERLINK l _Toc469212784 5.2.操作步驟 PAGEREF _Toc469212784 h 97 HYPERLINK l _Toc469212785 6.XSL Transformation PAGEREF _Toc469212785 h 99 HYPERLINK l _Toc469212786 4.1.4.Utility(15) PAGEREF _Toc4692127

53、86 h 99 HYPERLINK l _Toc469212787 .Change file encoding PAGEREF _Toc469212787 h 99 HYPERLINK l _Toc469212788 .Clone row PAGEREF _Toc469212788 h 99 HYPERLINK l _Toc469212789 .Delay row PAGEREF _Toc469212789 h 99 HYPERLINK l _Toc469212790 .Edit to xml PAGEREF _Toc469212790 h 99 HYPERLINK l _Toc4692127

54、91 .Execute a process PAGEREF _Toc469212791 h 99 HYPERLINK l _Toc469212792 .If field value is null PAGEREF _Toc469212792 h 99 HYPERLINK l _Toc469212793 .Mail PAGEREF _Toc469212793 h 99 HYPERLINK l _Toc469212794 .Metadata structure of stream PAGEREF _Toc469212794 h 99 HYPERLINK l _Toc469212795 .Null

55、if：設(shè)置為空值 PAGEREF _Toc469212795 h 99 HYPERLINK l _Toc469212796 .1.功能描述 PAGEREF _Toc469212796 h 99 HYPERLINK l _Toc469212797 0.Process files PAGEREF _Toc469212797 h 100 HYPERLINK l _Toc469212798 1.Run SSH commands PAGEREF _Toc469212798 h 100 HYPERLINK l _Toc469212799 2.Send message to Syslog PAGEREF _

56、Toc469212799 h 100 HYPERLINK l _Toc469212800 3.Table Compare PAGEREF _Toc469212800 h 100 HYPERLINK l _Toc469212801 4.Write to log PAGEREF _Toc469212801 h 100 HYPERLINK l _Toc469212802 5.Zip file PAGEREF _Toc469212802 h 100 HYPERLINK l _Toc469212803 5.1.功能描述 PAGEREF _Toc469212803 h 100 HYPERLINK l _T

57、oc469212804 5.2.操作步驟 PAGEREF _Toc469212804 h 100 HYPERLINK l _Toc469212805 4.1.5.Flow(16) PAGEREF _Toc469212805 h 102 HYPERLINK l _Toc469212806 .Abort：中止 PAGEREF _Toc469212806 h 102 HYPERLINK l _Toc469212807 .1.功能描述 PAGEREF _Toc469212807 h 102 HYPERLINK l _Toc469212808 .Annotate Stream PAGEREF _Toc4

58、69212808 h 102 HYPERLINK l _Toc469212809 .Append streams：追加流 PAGEREF _Toc469212809 h 102 HYPERLINK l _Toc469212810 .1.功能描述 PAGEREF _Toc469212810 h 102 HYPERLINK l _Toc469212811 .2.操作步驟 PAGEREF _Toc469212811 h 102 HYPERLINK l _Toc469212812 .Block this step unitil steps finish PAGEREF _Toc469212812 h

59、103 HYPERLINK l _Toc469212813 .Blocking Step：阻塞數(shù)據(jù) PAGEREF _Toc469212813 h 103 HYPERLINK l _Toc469212814 .1.功能描述 PAGEREF _Toc469212814 h 103 HYPERLINK l _Toc469212815 .2.操作步驟 PAGEREF _Toc469212815 h 103 HYPERLINK l _Toc469212816 .Detect empty stream PAGEREF _Toc469212816 h 104 HYPERLINK l _Toc4692128

60、17 .Dummy (do nothing)：空操作什么也不做 PAGEREF _Toc469212817 h 104 HYPERLINK l _Toc469212818 .1.功能描述 PAGEREF _Toc469212818 h 104 HYPERLINK l _Toc469212819 .ETL Metadata Injection PAGEREF _Toc469212819 h 105 HYPERLINK l _Toc469212820 .！Filter rows: 過濾記錄過濾行 PAGEREF _Toc469212820 h 105 HYPERLINK l _Toc4692128