I have a target table whose rows are being deleted correctly per my design each run in a BODS 3.2 job. However, I'm trying to read in this target table also as a source table prior to the rows being deleted at the start of the job. In the target Options tab I've tried "Delete data from table before loading" and I've also tried Pre-Load Commands tab "DELETE FROM xxx" indepedently, but both of these delete the rows prior to the source table reading them in. Any suggestions?
I think the target data is getting deleted when the loader is getting initialized and this is done before the read is started, if you are using the same table as source from which data is getting deleted then better option is to copy the data to a temp table and use that temp table as source (in a separate DF before this DF)