Kettle同步设计思路 - 数据库编程

TOP

Kettle同步设计思路(三)

2014-11-24 08:16:25 来源: 作者: 【大中小】浏览:13次

_FIRST_LETTER DRUG_FIRST_LETTER Y DRUG_LENGTH DRUG_LENGTH Y DRUG_HEIGHT DRUG_HIGH Y DRUG_WIDTH DRUG_WIDTH Y 909 552 Y 插入 / 更新IWMDS_DRUG_DETAIL 2 InsertUpdate Y 1 none serverConn 100 N IWMDS_DRUG_DETAIL

V_DRUG_CLASS_ID_C DRUG_ID = DRUG_DETAIL_ID V_DRUG_DETAIL_ID N DRUG_ID V_DRUG_CLASS_ID_C N REMARKS REMARKS Y MODIFY_TIME MODIFY_TIME Y MODIFIER MODIFIER Y IS_CONTROLLED IS_CONTROLLED Y INFO_ORDER INFO_ORDER Y IS_DELETE ENABLE_FLAG Y DRUG_UNIT DRUG_UNIT_CODE Y DRUG_SPECIFICATIONS DRUG_SPECIFICATIONS Y DRUG_INGREDIENT DRUG_INGREDIENT Y FORM_CODE DRUG_FORM_CODE Y DRUG_DESCRIPTION DRUG_DESCRIPTION Y DRUG_ENGLISH_NAME DRUG_COMMON_EN_NAME Y DRUG_NAME DRUG_COMMON_CN_NAME Y BASIC_CODE DRUG_CODE Y BRAND_ENGLISH_NAME DRUG_BRAND_EN_NAME Y BRAND_NAME DRUG_BRAND_CN_NAME Y CREATOR CREATOR Y CREATE_TIME CREATE_TIME Y DRUG_PINYIN DRUG_PINYIN Y DRUG_FIRST_LETTER DRUG_FIRST_LETTER Y DRUG_LENGTH DRUG_LENGTH Y DRUG_HEIGHT DRUG_HIGH Y DRUG_WIDTH DRUG_WIDTH Y 520 639 Y 数据库查询V_DRUG_CLASS_ID_C DBLookup Y 1 none serverConn N N 0 IWMDS_DRUG_CLASS

N N V_INFO_SOURCE_TYPE INFO_SOURCE_TYPE = DRUG_ID INFO_SOURCE_ID = DRUG_CLASS_ID V_DRUG_CLASS_ID_C String 521 419 Y 数据库查询V_DRUG_CLASS_STRUCT_ID DBLookup Y 1 none serverConn N N 0 IWMDS_DRUG_CLASS_STRUCT

N N V_INFO_SOURCE_TYPE INFO_SOURCE_TYPE = DRUG_STRUCT_ID INFO_SOURCE_ID = STRUCT_ID V_DRUG_CLASS_STRUCT_ID String 378 40 Y 更新 IWMDS_DRUG_BATCH Update Y 1 none serverConn N 100 N Y IWMDS_DRUG_BATCH

DRUG_ID ATTRIBUTE09 = DRUG_DETAIL_ID V_DRUG_DETAIL_ID MODIFY_TIME V_CURRENT_TIME 1115 395 Y 更新 IWMDS_PRESCRIPTION_DETAIL Update Y 1 none serverConn N 100 N Y IWMDS_PRESCRIPTION_DETAIL

DRUG_ID ATTRIBUTE09 = DETAIL_ID V_DRUG_DETAIL_ID MODIFY_TIME V_CURRENT_TIME 1116 558 Y 表输入 TableInput Y 1 none serverConn SELECT DRUG_ID , DRUG_CODE , DRUG_COMMON_CN_NAME , DRUG_COMMON_EN_NAME , IS_CONTROLLED , DRUG_BRAND_CN_NAME , DRUG_BRAND_EN_NAME , DRUG_FORM_CODE , DRUG_UNIT_CODE , DRUG_SPECIFICATIONS , DRUG_DESCRIPTION , DRUG_INGREDIENT , DRUG_STRUCT_ID , INFO_ORDER , DRUG_LENGTH , DRUG_HIGH , DRUG_WIDTH , REMARKS , ENABLE_FLAG , CREATOR , to_date(create_time,'yyyy-mm-dd hh24:mi:ss') CREATE_TIME , MODIFIER , to_date(MODIFY_TIME,'yyyy-mm-dd hh24:mi:ss') MODIFY_TIME , ATTRIBUTE01 , ATTRIBUTE02 , ATTRIBUTE03 , ATTRIBUTE04 , ATTRIBUTE05 , DRUG_PINYIN || ',' || f_getFirstOrFullSpell(drug_common_cn_name,1) ||','||f_getFirstOrFullSpell(DRUG_BRAND_CN_NAME,1) DRUG_PINYIN , DRUG_FIRST_LETTER || ','||f_getFirstOrFullSpell(drug_common_cn_name) ||',' || f_getFirstOrFullSpell(DRUG_BRAND_CN_NAME) DRUG_FIRST_LETTER, SYSDATE V_CURRENT_TIME FROM HIS_DRUG 0 N N N 144 37 Y 调用DB存储过程V_DRUG_CLASS_COUNT DBProc Y 1 none serverConn F_SYNC_GET_DRUG_CLASS_COUNT DRUG_ID IN String V_DRUG_CLASS_COUNT String Y 729 40 Y 调用DB存储过程V_DRUG_CLASS_ID DBProc Y 1 none serverConn CREATEGUID V_DRUG_CLASS_ID String Y 137 227 Y 调用DB存储过程V_DRUG_DE

首页上一页 1 2 3 4 下一页尾页 3/4/4
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】
分享到:
上一篇：hadoop用户权限管理	下一篇：考勤问题思路和解决

帐　　号:

密码: (新用户注册)

验证码:

表　　情:

内　　容: