用agg组建& tgt pre load 过滤src 重复数据
src 6 个字段, 有重复数据。
group the src rows by first 5 columns using agg
give 'null' to the 6th column with an expression.
in tgt pre load: delete * from tgt where 6th column is null
StartYear StartMonth EndYear EndMonth ForceRun ProcessDate
2014 9 2014 9 0 4
控制表
‘$$StartMonth=’||IIF(ForceRun='1',
to_char(LPAD(startmonth,2,'0')),
IIF(to_char(sysdate,'dd')=to_char(processdate),
to_char(add_to_date(sysdate,'MM',-1),'MM')))
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30090120/viewspace-1392502/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30090120/viewspace-1392502/