Hi there
I've a fact build where the datasource query is as follow
SELECT "Id", "InternalOrder", "Value", "Date",
FROM "dbo"."NonLaborValues"
WHERE "Date" > _add_months(sysdate(),-1)
using UPDATE/INSERT
My problem is that it may happen that in the source a entry is deleted. As I can not detect this deletion I would like to extend this build or create a new one to run
delete from "dbo"."NonLaborValues"
WHERE "Date" > _add_months(sysdate(),-1)
beforehand.
Can I include this delete statement in the Query of the data source. Or ..
Thank you for your help
erwin