ÔÆÌ⺣ - רҵÎÄÕ·¶ÀýÎĵµ×ÊÁÏ·ÖÏíÆ½Ì¨

µ±Ç°Î»ÖãºÊ×Ò³ > ETLʹÓÃÊÖ²á

ETLʹÓÃÊÖ²á

  • 62 ´ÎÔĶÁ
  • 3 ´ÎÏÂÔØ
  • 2025/7/7 0:19:55

·´Ï´Ç®ÏµÍ³

Password.

Ô´Êý¾Ý¿âJDBCÊôÐÔÖµ.

value

Ö±½Ó¶ÔӦת»»ÁÐ

ÊôÐÔ

sourceColumnName targetTableName targetColumnName targetTableID

valueMode

defaultValue toHex fromHex

ÃèÊö

Ô´Êý¾Ý¿â±í×Ö¶ÎÃû³Æ£¬Õâ¸öÊôÐÔ±ØÐë¡£ Ä¿±êÊý¾Ý¿â±íÃû£¬Õâ¸öÊôÐÔ±ØÐë¡£

Ä¿±êÊý¾Ý¿â±í×Ö¶ÎÃû³Æ£¬Õâ¸öÊôÐÔ±ØÐë¡£

¶¨ÒåÂß¼­Ä¿±ê±íÊýÁ¿£¬¿ÉÄÜÒ»¸öÕæÊµÄ¿±ê±íÖ¸¶¨Îª¶à¸öÂß¼­Ä¿±ê±í¡£Õâ¸öÊôÐÔµÄÖµ´Ó0¿ªÊ¼¡£Õâ¸öÊôÐÔÊDZØÐèµÄ£¬¿ÉÒÔ¶¨Òå¶à¸öÂß¼­±íÖ¸¶¨ÏàͬµÄÎïÀí±í¡£

¶¨ÒåÊý¾ÝÐÞ¸Äģʽ¡£Öµ°üÀ¨£º Key, Overwrite, Update, SetIfCreated£¬SetNull.Õâ¸öÊôÐÔÊDZØÐèµÄ¡£¡®Key¡¯ ¨C ¶¨Òå³ÉKEYµÄÄ¿±ê±í×Ö¶ÎÓÃÀ´È·¶¨Ò»ÐÐÊý¾Ý£¨Ö÷¼ü¹¦ÄÜ£©¡£

¡®Overwrite¡¯ - ¶¨Òå³ÉOverwriteµÄÄ¿±ê±í×ֶΣ¬½«°ÑÔ´±í×Ö¶ÎÊý¾Ý¸²¸ÇÄ¿±ê±í×ֶεÄÊý¾Ý¡£¡®Update¡¯ -¶¨Òå³ÉUpdateµÄÄ¿±ê±í×ֶΣ¬Ö»ÐÞ¸ÄÄ¿±ê±í×Ö¶ÎΪ¿ÕµÄÊý¾Ý¡£¡®SetIfCreated¡¯ -¶¨Òå³ÉSetIfCreatedµÄÄ¿±ê±í×ֶΣ¬Ö»ÔÚ²åÈëÐÂÊý¾ÝÐÐʱ°ÑÔ´±í×Ö¶ÎÊý¾Ýתµ½Ä¿±ê±í×ֶεÄÊý¾Ý¡£¡®SetNull¡¯ ¨C¶¨Òå³ÉSetIfCreatedµÄÄ¿±ê±í×ֶΣ¬½«Ä¿±ê±í×ֶεÄÊý¾ÝÉè³ÉNULL¡£

Õâ¸öÊôÐÔ¿ÉÑ¡£¬Èç¹û×Ö¶ÎÊý¾ÝΪNULLʱ£¬¿ÉÒÔÖ¸¶¨Ä¬ÈÏÖµ¡£ ¿Éѡֵ£º true »òfalse.Èç¹ûtoHex µÄÊôÐÔÉè³Étrue,Êý¾Ý×Ö¶ÎBLOBÀàÐ͵ÄÖµ½«Òª±»×ª»»³ÉStringÀàÐÍ¡£

¿Éѡֵ£º true »òfalse.Èç¹ûfromHexµÄÊôÐÔÉè³Étrue,Êý¾Ý×Ö¶ÎStringÀàÐ͵ÄÖµ½«Òª±»×ª»»³ÉBLOBÀàÐÍ¡£

ÀýÈ磺

×Ô¶¨Òåת»»¹æÔò£¬ÀýÈ磺

13

·´Ï´Ç®ÏµÍ³

retVal = new Array();

retVal[0] = JRJGDM_ZHJLBS+YWH_ZHJLBS; retVal[1] = JRJGDM_ZHJLBS+YWH_ZHJLBS; retVal[2] = JRJGDM_ZHJLBS+YWH_ZHJLBS; retVal[3] = dateconversion(KHRQ); retVal[4] = dateconversion(DQRQ); retVal[5] = getInt(SXED); retVal[6] = getInt(GXSXED); retVal;

14

·´Ï´Ç®ÏµÍ³

ת»»¹æÔò ÊôÐÔ ÃèÊö name ת»»¹æÔòÃû³Æ

transformatorClassName ͨ¹ýµ÷ÓÃjavaÀàת»»Êý¾Ý£¬ÒªÖ¸¶¨ÀàµÄÍêÕûÃû³Æ¡£

£¨org.webdocwf.util.loader.transformation. ReplaceDataFromDesDB£©

transformatorConfig Ö¸¶¨Ïòת»»ÀࣨÀýÈ磺ReplaceDataFromDesDB£©Öд«µÝ

µÄ²ÎÊý£¬Ö»ÄÜ´«µÝÒ»¸ö²ÎÊý¡£

Ô´±íÊý¾Ý×Ö¶Î

Ô´±í×ֶΣ¬ÀýÈ磺

Ä¿±ê±íÊý¾Ý×Ö¶Î

Ä¿±ê±í×Ö¶Î ÊôÐÔ ÃèÊö name Ä¿±ê±í×Ö¶ÎÃû³Æ tableName Ä¿±ê±íÃû tableID Ä¿±ê±íµÄÂß¼­IDºÅ

valueMode ÖµµÄת»»Ä£Ê½£º (Update,SetNull,Overwrite,Key) °üÀ¨£º Key,

Overwrite, Update, SetIfCreated£¬SetNull.Õâ¸öÊôÐÔÊDZØÐèµÄ¡£¡®Key¡¯ ¨C ¶¨Òå³ÉKEYµÄÄ¿±ê±í×Ö¶ÎÓÃÀ´È·¶¨Ò»ÐÐÊý¾Ý£¨Ö÷¼ü¹¦ÄÜ£©¡£

¡®Overwrite¡¯ - ¶¨Òå³ÉOverwriteµÄÄ¿±ê±í×ֶΣ¬½«°ÑÔ´±í×Ö¶ÎÊý¾Ý¸²¸ÇÄ¿±ê±í×ֶεÄÊý¾Ý¡£¡®Update¡¯ -¶¨Òå³ÉUpdateµÄÄ¿±ê±í×ֶΣ¬Ö»ÐÞ¸ÄÄ¿±ê±í×Ö¶ÎΪ¿ÕµÄÊý¾Ý¡£¡®SetIfCreated¡¯ -¶¨Òå³ÉSetIfCreatedµÄÄ¿±ê±í×ֶΣ¬Ö»ÔÚ²åÈëÐÂÊý¾ÝÐÐʱ°ÑÔ´±í×Ö¶ÎÊý¾Ýתµ½Ä¿±ê±í×ֶεÄÊý¾Ý¡£¡®SetNull¡¯ ¨C¶¨Òå³ÉSetIfCreatedµÄÄ¿±ê±í×ֶΣ¬½«Ä¿±ê±í×ֶεÄÊý¾ÝÉè³ÉNULL¡£

javascript½Å±¾×ª»»£¬ÀýÈ磺

15

·´Ï´Ç®ÏµÍ³

retVal = new Array();

retVal[0] = JRJGDM_ZHJLBS+YWH_ZHJLBS; retVal[1] = JRJGDM_ZHJLBS+YWH_ZHJLBS; retVal[2] = JRJGDM_ZHJLBS+YWH_ZHJLBS; retVal[3] = dateconversion(KHRQ); retVal[4] = dateconversion(DQRQ); retVal[5] = getInt(SXED); retVal[6] = getInt(GXSXED); retVal;

°üº¬½Å±¾£¬ÀýÈ磺

ÊôÐÔ ÃèÊö

href °üº¬Îļþ·¾¶

parse °üº¬ÎļþÀàÐÍ (text)

»ñµÃ±äÁ¿Öµ×ֶΣ¬ÀýÈ磺

targetColumnName=\

½«±äÁ¿Öµ¸³¸øÄ¿±ê×ֶαØÐëÊôÐÔoverride=\ÊôÐÔ ÃèÊö name ±äÁ¿Ãû³Æ

targetTableName Ä¿±ê±íÃû£¬Õâ¸öÊôÐÔ±ØÐë¡£ targetColumnName Ä¿±ê±í×Ö¶ÎÃû£¬Õâ¸öÊôÐÔ±ØÐë¡£ targetTableID Ä¿±ê±íÂß¼­IDºÅ£¬¿ÉÄÜÒ»¸öÕæÊµÄ¿±ê±íÖ¸¶¨Îª¶à¸öÂß¼­Ä¿±ê±í¡£

Õâ¸öÊôÐÔµÄÖµ´Ó0¿ªÊ¼¡£Õâ¸öÊôÐÔÊDZØÐèµÄ£¬¿ÉÒÔ¶¨Òå¶à¸öÂß¼­±íÖ¸¶¨ÏàͬµÄÎïÀí±í¡£

16

ËÑË÷¸ü¶à¹ØÓÚ£º ETLʹÓÃÊÖ²á µÄÎĵµ
  • ÊÕ²Ø
  • Î¥¹æ¾Ù±¨
  • °æÈ¨ÈÏÁì
ÏÂÔØÎĵµ10.00 Ôª ¼ÓÈëVIPÃâ·ÑÏÂÔØ
ÍÆ¼öÏÂÔØ
±¾ÎÄ×÷Õߣº...

¹²·ÖÏí92ƪÏà¹ØÎĵµ

Îĵµ¼ò½é£º

·´Ï´Ç®ÏµÍ³ Password. Ô´Êý¾Ý¿âJDBCÊôÐÔÖµ. value Ö±½Ó¶ÔӦת»»ÁÐ ÊôÐÔ sourceColumnName targetTableName targetColumnName targetTableID valueMode defaultValue toHex fromHex ÃèÊö Ô´Êý¾Ý¿â±í×Ö¶ÎÃû³Æ£¬Õâ¸öÊôÐÔ±ØÐë¡£ Ä¿±êÊý¾Ý¿â±íÃû£¬Õâ¸öÊôÐÔ±ØÐë¡£ Ä¿±êÊý¾Ý¿â±í×Ö¶ÎÃû³Æ£¬Õâ¸öÊôÐÔ±ØÐë¡£ ¶¨ÒåÂß¼­Ä¿±ê±íÊýÁ¿£¬¿ÉÄÜÒ»¸öÕæÊµÄ¿±ê±íÖ¸¶¨Îª¶à¸öÂß¼­Ä¿±ê±í¡£Õâ¸öÊôÐÔµÄÖµ´Ó0¿ªÊ¼¡£Õâ¸öÊôÐÔÊDZØÐèµÄ£¬¿ÉÒÔ¶¨Òå¶à¸öÂß¼­±íÖ¸¶¨ÏàͬµÄÎïÀí±í¡£ <

¡Á ÓοͿì½ÝÏÂÔØÍ¨µÀ£¨ÏÂÔØºó¿ÉÒÔ×ÔÓɸ´ÖƺÍÅŰ棩
µ¥Æª¸¶·ÑÏÂÔØ
ÏÞÊ±ÌØ¼Û£º10 Ôª/·Ý Ô­¼Û:20Ôª
VIP°üÔÂÏÂÔØ
ÌØ¼Û£º29 Ôª/Ô ԭ¼Û:99Ôª
µÍÖÁ 0.3 Ôª/·Ý ÿÔÂÏÂÔØ150·Ý
ȫվÄÚÈÝÃâ·Ñ×ÔÓɸ´ÖÆ
VIP°üÔÂÏÂÔØ
ÌØ¼Û£º29 Ôª/Ô ԭ¼Û:99Ôª
µÍÖÁ 0.3 Ôª/·Ý ÿÔÂÏÂÔØ150·Ý
ȫվÄÚÈÝÃâ·Ñ×ÔÓɸ´ÖÆ
×¢£ºÏÂÔØÎĵµÓпÉÄÜ¡°Ö»ÓÐĿ¼»òÕßÄÚÈݲ»È«¡±µÈÇé¿ö£¬ÇëÏÂÔØÖ®Ç°×¢Òâ±æ±ð£¬Èç¹ûÄúÒѸ¶·ÑÇÒÎÞ·¨ÏÂÔØ»òÄÚÈÝÓÐÎÊÌ⣬ÇëÁªÏµÎÒÃÇЭÖúÄã´¦Àí¡£
΢ÐÅ£ºfanwen365 QQ£º370150219
Copyright © ÔÆÌ⺣ All Rights Reserved. ËÕICP±¸16052595ºÅ-3 ÍøÕ¾µØÍ¼ ¿Í·þQQ£º370150219 ÓÊÏ䣺370150219@qq.com