Kettleѧϰ

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

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)