Lookup transformation:
ports type:
I: Input
O: Output
L: lookup
R: Return ( for unconnected Lookup)
调用unconnected lookup transformation:
syntax: :LKP.lookup_Transformation_Name(arg1,arg2....)
注意:这里的arg1,arg2,顺序与lookup transformation 中condition expression的column顺序一致
Update Strategy Transformation:
一些标识update操作的常量:
DD_Insert: 插入新纪录,实际值是 0
DD_Update: 更新记录,实际值是 1
DD_Delete: 删除记录,实际值是 2
DD_Reject: 阻止记录流入下个transformation ,实际值是 3
其他数值,4,5,6……均表示DD_Insert