1¡¢ÏµÍ³ÈÕÆÚ(¿É±ä)£ºÏµÍ³Ê±¼ä£¬Ã¿´Î·ÃÎʶ¼13¡¢±¾ÔµĵÚÒ»Ìì00:00:00£ºÕâ¸öÔµĿªÊ¼ 14¡¢±¾ÔµÄ×îºóÒ»Ìì23:59:59£ºÕâ¸öÔµĽáÊø 15¡¢²½Ö追±´£º¸´ÖƲ½Öè 16¡¢×ª»»Ãû³Æ£º×ª»»µÄÃû³Æ
17¡¢×ª»»µÄÎļþÃû£º×ª»»µÄÎļþÃû(½öÕë¶ÔXML) 18¡¢×îºóÐÞ¸Äת»»µÄÓû§ 19¡¢×ª»»µÄ×îºóÐÞ¸ÄÈÕÆÚ
20¡¢×ª»»ID£ºÈÕÖ¾±íÖеÄÅú´¦ÀíIDÖµ 22¡¢Ö÷»úÃû£º·µ»Ø·þÎñÆ÷µÄÖ÷»úÃû 23¡¢IPµØÖ·£º·µ»Ø·þÎñÆ÷µÄIPµØÖ·
24¡¢ÃüÁîÐвÎÊý1£ºÃüÁîÐеĵÚÒ»¸ö²ÎÊý¡£ 25¡¢Kettle°æ±¾£º·µ»ØKettleµÄ°æ±¾¡£
26£ºKettle±àÒë°æ±¾£º·µ»ØKettleºËÐÄ¿âµÄ±àÒë°æ±¾ 27£ºKettle±àÒëÈÕÆð£ºKettleºËÐÄ¿âµÄ±àÒëÈÕÆÚ 28£ºCurrent process identifier(PID)£º
Ôڸı䡣
2¡¢ÏµÍ³ÈÕÆÚ(¹Ì¶¨)£ºÏµÍ³Ê±¼ä£¬ÓÐת»»¿ªÊ¼À´¾ö¶¨¡£¼´×ª»»¿ªÊ¼Ê±¼ä
3¡¢¿ªÊ¼ÈÕÆÚ·¶Î§(ת»»)£º¸ù¾ÝetlÈÕÖ¾±íµÄÐÅÏ¢£¬È·¶¨ÈÕÆÚ·¶Î§µÄ¿ªÊ¼¡£
4¡¢½áÊøÈÕÆÚ·¶Î§(ת»»)£º¸ù¾ÝetlÈÕÖ¾±íµÄÐÅÏ¢£¬È·¶¨ÈÕÆÚ·¶Î§µÄ½áÊø¡£
5¡¢¿ªÊ¼ÈÕÆÚ·¶Î§(×÷Òµ)£º¸ù¾ÝetlÈÕÖ¾±íµÄÐÅÏ¢£¬È·¶¨ÈÕÆÚ·¶Î§µÄ¿ªÊ¼
6¡¢½áÊøÈÕÆÚ·¶Î§(×÷Òµ)£º¸ù¾ÝetlÈÕÖ¾±íµÄÐÅÏ¢£¬È·¶¨ÈÕÆÚ·¶Î§µÄ½áÊø¡£ 7¡¢×òÌì00:00:00£º×òÌìµÄ¿ªÊ¼ 8¡¢×òÌì23:59:59£º×òÌìµÄ½áÊø 9¡¢½ñÌì00:00:00£º½ñÌìµÄ¿ªÊ¼ 10¡¢½ñÌì23:59:59£º½ñÌìµÄ½áÊø
11¡¢ÉϸöÔµÚÒ»ÌìµÄ00:00:00£ºÉϸöÔµĿªÊ¼
12¡¢ÉϸöÔÂ×îºóÒ»ÌìµÄ23:59:59£ºÉϸöÔ½áÊø
Éú³É¼Ç¼
1¡¢ ÏÞÖÆ£º¼Ç¼ÊýµÄÌõÊý 2¡¢ Ãû³Æ¡¢Öµ
9 / 42
CubeÊäÈë
´Ó¶þ½øÖÆKettle CubeÎļþÖжÁÈ¡Êý¾ÝÐÐ
XbaseÊäÈë
ʹÓÃÕâÒ»²½¿ÉÒÔ¶ÁÈ¡´ó¶àÊý±»³ÆÎªXbase familyÅÉÉúµÄDBFÎļþ 1¡¢ ×î³£ÓõÄÊÇFoxPro
ExcelÊäÈë
1¡¢ ¹¤×÷±íÃû³Æ
2¡¢ ÆðʼÐÐ £º¿ªÊ¼¶ÁÈ¡µÄÐС£ 3¡¢ ÆðʼÁУº¿ªÊ¼¶ÁÈ¡µÄÁС£
4¡¢ Í·²¿£º¼ì²é¹¤×÷±íÊÇ·ñÖ¸¶¨ÁËÒ»¸öÍ·²¿ÐС£ 5¡¢ ·Ç¿Õ¼Ç¼£º¼ì²éÊÇ·ñ²»ÐèÒª¿ÕÐÐÊä³ö¡£ 6¡¢ Í£ÔڿռǼ£ºµ±Óö¿ÕÐÐʱֹͣ¶ÁÈ¡¡£
7¡¢ ÎļþÃû³Æ×ֶΣº²½ÖèÊä³öÖ¸¶¨Ò»¸ö°üº¬ÎļþÃûµÄ×ֶΡ£
8¡¢ ¹¤×÷±íÃû³Æ×ֶΣº²½ÖèÊä³öÖ¸¶¨Ò»¸ö°üº¬¹¤×÷±íÃû³ÆµÄ×ֶΡ£ 9¡¢ ÐкÅÁУºÖ¸¶¨Êä³öÐкÅÁÐ×Ö¶ÎÃû³Æ¡£
XMLÊäÈë
1¡¢ Loop XPath£º Ñ¡Ôñ/Rows/Row 2¡¢ Namespace aware:
3¡¢ Ignore comments:ºöÂÔ×¢ÊÍ
4¡¢ Validate XML£ºÑéÖ¤XML £¬Ò»°ã²»ÑéÖ¤ 5¡¢ Ignore empty file£ººöÂÔ¿ÕÎļþ
6¡¢ Include filename in output£ºÊä³ö²½Öè°üº¬ÎļþÃû×Ö¶Î 7¡¢ Rownum in output£ºÊä³ö°üº¬ÐкÅ×ֶΡ£
»ñÈ¡ÎļþÃû
1¡¢ Get£ºAll files¡¢Only folders¡¢Only files
2¡¢ Êä³ö×ֶΰüº¬£ºfilename¡¢short_filename¡¢path¡¢type(file/folder)¡¢exists(Y/N)¡¢ishidden¡¢
isreadable¡¢iswriteable¡¢lastmodifiedtime¡¢size¡¢extension(À©Õ¹Ãû)¡¢uri¡¢rooturi
»ñÈ¡ÎļþÐÐÊý
1¡¢Rows Separator type£ºCarriage Return
10 / 42
Îı¾ÎļþÊä³ö
1¡¢ Run this as a command instead£º°Ñ½á¹ûÊä³öµ½ÃüÁîÐлòÕ߽ű¾
2¡¢ ÎļþÃûÀï°üº¬²½ÖèÊý£ºÈç¹ûÄãÔÚ¶à¸ö¿½±´ÖÐÔËÐв½Ö裬¿½±´µÄÊýÁ¿½«°üº¬µ½ÎļþÃûÖС£ 3¡¢ Include partition nr in filename£ºÎļþÃûÖаüº¬Êý¾Ý·ÖÇøÊýÁ¿ 4¡¢ ÎļþÃû°üº¬ÈÕÆÚ 5¡¢ ÎļþÃû°üº¬Ê±¼ä 6¡¢ ×·¼Ó 7¡¢ ·Ö¸ô·û
8¡¢ ·â±Õ·û£º·â±Õ×ֶεÄÒ»¶Ô×Ö·û£¬¿ÉÑ¡ 9¡¢ Ç¿ÖÆÔÚ×Ö¶ÎÖÜΧ¼ÓÉÏ·â±Õ·û 10¡¢ Í·²¿£ºÈç¹ûÏíÓÐÒ»¸öÍ·²¿ÐУ¬Ñ¡ÖÐ 11¡¢ β²¿£ºÈç¹ûÏíÓÐÒ»¸öβ²¿ÐУ¬Ñ¡ÖÐ 12¡¢ ¸ñʽ£ºDOSÎļþµÄ·Ö¸ô·û¿ÉÒÔÊǻسµ»ò»»Ðзû 13¡¢ ±àÂ룺ָ¶¨±àÂ룬Èç¹û¿Õ°×¾ÍÊÇÓÃϵͳȱʡµÄ±àÂë 14¡¢ Compression(ѹËõ)£ºÖ¸¶¨Ñ¹ËõµÄÀàÐÍ(zip,gzip) 15¡¢ Right pad fields£ºÔÚ×Ö¶Î×îºóÌí¼Ó¿Õ¸ñ»òÕßɾ³ý×Ö·û£¬Ö±µ½³¤¶È´ïµ½Ö¸¶¨ 16¡¢ Fast data dump(no formatting)£ºµ±´¦Àí´óÁ¿Êý¾Ýµ½Ò»¸öÎı¾Îļþʱ£¬Ìá¸ßÐÔÄÜ.£¨²»
°üº¬Èκθñʽ»¯ÐÅÏ¢£© 17¡¢ ·Ö²ðÿһÐУºÈç¹ûn±È0´ó£¬ÓÃnÐвð·ÖÎı¾Îļþ£¬·Ö¸î³É¶à¸ö²¿·Ö¡£ 18¡¢ Add Ending line of file£ºÖ¸¶¨Êä³öÎı¾µÄ¶î½áÊøÐС£
±íÊä³ö
1¡¢ Target Schema£ºÄ¿±êģʽ¡£ÒªÐ´Êý¾ÝµÄ±íµÄSchemaµÄÃû³Æ¡£ÔÊÐí±íÃ÷Öаüº¬¡°¡£¡±¶ÔÊý
¾ÝÔ´À´ËµÊǺÜÖØÒªµÄ
2¡¢ Ä¿±ê±í£ºÒªÐ´Êý¾ÝµÄ±íÃû¡£
3¡¢ Ìá½»¼Ç¼ÊýÁ¿£ºÔÚÊý¾Ý±íÖÐÓÃÊÂÎï²åÈëÐС£Èç¹ûn±È0´ó£¬Ã¿nÐÐÌá½»Ò»´ÎÁ¬½Ó¡£·ñÔò
²»Ê¹ÓÃÊÂÎñ£¬ËÙ¶È»áÂýһЩ¡£
4¡¢ ²Ã¼ô±í£ºÔÚµÚÒ»ÐÐÊý¾Ý²åÈë֮ǰ²Ã¼ô±í¡£
5¡¢ ºöÂÔ²åÈë´íÎó£ºÊ¹KettleºöÂÔ±ÈÈçÎ¥·´Ö÷¼üÔ¼ÊøÖ®ÀàµÄ²åÈë´íÎó£¬×î¶à20¸ö¾¯¸æ½«±»
ÈÕÖ¾¼Ç¼¡£ÔÚÅúÁ¿²åÈëµÄʱºòÕâ¸ö¹¦Äܲ»¿ÉÓᣠ6¡¢ ʹÓÃÅúÁ¿²åÈ룺Õâ¸öÑ¡ÏîËٶȿ죬ĬÈϱ»Ñ¡ÉÏ¡£
7¡¢ ±í·ÖÇøÊý¾Ý£ºÊ¹ÓÃÕâ¸öÑ¡Ïî¿ÉÒÔÔÚ¶à¸ö±íÖ®¼ä²ð·ÖÊý¾Ý¡£ÀýÈç°ÑÊý¾Ý·Åµ½±ís1¡¢s2¡¢s3
ÖÐÀ´´úÌæÖ®¼ä²åÈëÊý¾Ýµ½±ísÖС£ ÀýÈ磺create or replace view sales as Select * from sales_200501 Union all Select * from sales_200502
8¡¢ ±íÃû¶¨ÒåÔÚÒ»¸ö×Ö¶ÎÀʹÓôËÑ¡Ïî¿ÉÒÔ²ð·ÖÊý¾Ýµ½Ò»¸ö»òÕß¶à¸ö±íÀĿ±ê±íÃû¿ÉÒÔ
ÓÃÄãÖ¸¶¨µÄ×Ö¶ÎÀ´¶¨Òå¡£ÀýÈçÈç¹ûÄãÏë´æ´¢¿Í»§ÐÔ±ðÊý¾Ý£¬ÕâЩÊý¾Ý¿ÉÄÜ»á´æ´¢µ½±íMºÍ±íFÀïÃæ¡£Õâ¸öÑ¡Ïî¿ÉÒÔ×èÖ¹ÕâЩ×ֶβåÈëµ½ÏàÓ¦µÄ±íÀï¡£
9¡¢ ·µ»ØÒ»¸ö×Ô¶¯²úÉúµÄ¹Ø¼ü×Ö£ºÍù±íÖвåÈëÐÐʱ£¬ÊÇ·ñ²úÉúÒ»¸ö¹Ø¼ü×Ö¡£
11 / 42
10¡¢ ×Ô¶¯²úÉú¹Ø¼ü×ÖµÄ×Ö¶ÎÃû³Æ£ºÖ¸¶¨°üº¬¹Ø¼ü×ÖµÄÊä³ö×ֶεÄ×Ö¶ÎÃû³Æ¡£
²åÈë/¸üÐÂ
1¡¢ target schema£ºÒªÐ´ÈëÊý¾ÝµÄ±íµÄschemaÃû³Æ¡£ÔÊÐí±íÃû°üº¬¡±.¡±ÊǺÜÖØÒªµÄ¡£ 2¡¢ commit size£ºÌύ֮ǰҪ¸Ä±äµÄÐÐÊý(²åÈë/¸üÐÂ)¡£
3¡¢ ²»Ö´ÐÐÈκθüУºÈç¹û±»Ñ¡Ôñ£¬Ôò²»Ö´ÐÐÈκθüУ¬Ö»ÔÊÐí²åÈë¡£
4¡¢ ÓÃÀ´²éѯµÄ¹Ø¼ü×Ö£º¿ÉÒÔÖ¸¶¨×Ö¶ÎÖµ»òÕ߱ȽϷû¡£¿ÉÒÔÓÃÒÔϱȽϷû£º>¡¢>=¡¢=¡¢<>¡¢
<¡¢<=¡¢between¡¢like¡¢is null¡¢is not null
5¡¢ ÓÃÀ´²éѯµÄ¹Ø¼ü×Ö£ºÊäÈëÓÃÀ´Ö¸¶¨¼Ç¼µÄ¹Ø¼ü×Ö¡£ 6¡¢ ¸üÐÂ×ֶΣºÖ¸¶¨ÏëÒª²åÈë/¸üеÄ×ֶΡ£
¸üÐÂ(¿ÉÒÔÓòåÈë/¸üÐÂÌæ´ú)
¸üÐÂÖ»ÄÜÓÃÀ´¸üУ¬²»ÄÜÓÃÀ´²åÈëÊý¾Ý¡£
ɾ³ý
Ö´ÐÐɾ³ý²Ù×÷¡£
×¢Ò⣺ÔÚÊä³öÖУ¬²åÈë/¸üС¢É¾³ý¡¢¸üжÔÓ¦µÄÊÇÊý¾Ý¿âµÄÔö¡¢É¾¡¢¸Ä¡£
ÐòÁл¯µ½Îļþ(ÒÔǰÊÇCube output)
Õâ¸ö²½Öè´æ´¢Êý¾Ýµ½Ò»¸ö¶þ½øÖÆÎļþ¡£Õâ¸ö²½ÖèÓиöÓÅÊÆ¾ÍÊǻضÁµÄʱºò£¬Îı¾ÎļþµÄÄÚÈݲ»ÐèÒª½âÎö¡£ÕâÊÇÒòΪԪÊý¾ÝҲͬʱ´æ´¢ÔÚcubeÎļþÖС£ ÓÃÊä³öµÄCubeÎļþ£¬ÓÃcubeÊäÈë¶ÁÈëÎļþÁ·Ï°Ï¡£
XMLÊä³ö
1¡¢ ÎļþÃûÖаüº¬²½ÖèºÅÂ룺Èç¹ûÄãÔÚ¶à¸ö¿½±´ÖÐÔËÐÐÒ»¸ö²½Ö裬ÔÚÎļþÀ©Õ¹ÃûµÄÇ°Ãæ£¬½«
°üº¬¿½±´µÄºÅÂë¡£
2¡¢ ·Ö¸îÿһ¸öÐУºÃ¿¸öxmlÎļþÖаüº¬µÄ¼Ç¼Êý¡£0±íʾ²»·Ö¸î¡£ 3¡¢ ÕýÔÚ±àÂ룺ÔÚXMLÎļþÍ·²¿Ö¸¶¨¡£ 4¡¢ ×Ö¶ÎÑ¡Ï
5¡¢ ÔªËØÃû³Æ£ºxmlÎļþʹÓõÄÔªËØµÄÃû³Æ£¬²»Ö¸¶¨£¬ÔòÔªËØÃû³ÆºÍ×Ö¶ÎÃûÏàͬ¡£ 6¡¢ 10½øÖÆ£ºÐ¡Êýµã¿ÉÒÔÊÇ¡±.¡±»òÕß¡±,¡± 7¡¢ ·Ö×飺·Ö×é·û¿ÉÒÔÊÇ¡±,¡±»òÕß¡±.¡±
8¡¢ ¿Õ£º±íʾµ±×Ö¶ÎֵΪ¿Õʱ£¬ÔòÓôË×Ö¶ÎÖµ´úÌæ¡£
12 / 42