cancel
Showing results for 
Search instead for 
Did you mean: 

BODS 3.2: Read in target table as source table before rows deleted

brad_schroeter2
Explorer
0 Kudos

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?

Thanks,

Brad

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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)

Answers (1)

Answers (1)

brad_schroeter2
Explorer
0 Kudos

Manoj,

Thanks for the reply. Yes, that's what I ended up doing yesterday: added new dataflow (prior to existing dataflow) where I read in table into temp table, and then in existing dataflow I changed the input to be the temp table.

-Brad