(15)清理中间表脚本: delete from f_sale_temp;
(16)抽取事实表脚本:
提取销售单据数据
select fdate as fdate, orderid as fbillno,goodsid as fitemid,departmentid as fdeptid,totaldecimal as famount,totalmoney as fcost,quantity as fqty,saleprice as fprice from ICstockbill
插入目的表脚本:
delete from f_sale; insert into f_sale(fdate,fbillno,fitemid,fdeptid,famount,fcost,fqty,fprice) select fdate,fbillno,fitemid,fdeptid,famount,fcost,fqty,fprice from f_sale_temp; 7.5 执行监控 (1)添加完任务后,点击执行监控 (2)在执行监控界面选择基础资料流程,点击执行按钮 (3)选择执行方式,从某点开始选择从START开始,点击执行 (4)执行完毕后,会显示出执行的结果详细信息,如下图所示 执行成功后,在数据库可查询到数据