首页 > 代码库 > Kettle笔记: Transformation 笔记

Kettle笔记: Transformation 笔记

触发器表输入:select a.*,b.*,0 as ztflag from exchange_trigger a left join MAEA_NET_BIZ_BASEINFO b

 on (a.keyvalue=http://www.mamicode.com/b.id) where a.flag=0 and a.tablename=‘MAEA_NET_BIZ_BASEINFO‘

附件处理脚本:

//Script here

var byte_FILEDATA = http://www.mamicode.com/null;

if(FILEDATA != null && FILEDATA != ‘‘){

var bb = new  Packages.java.lang.String(FILEDATA);

byte_FILEDATA = http://www.mamicode.com/bb.getBytes();

}