Skip to Content
avatar image
Former Member

Delta Load In DBConnect in BW 7.3

I have quick query, i know i can use DbConnect to bring in delta changes happening at source database level. I have loaded my target table, in case user at source database deletes the record at source table , will it delete the record at target table. What i understood from DBConnect delta load is, it does lookup on source table based on time/timestamp field and find changed data , in this case only inserted and updated data would come but what about deleted data. If it does not capture deleted delta then is there any solution how we capture it.? What record level setting should i enable in BW like this

  • FIL1 (Delta with Delta Images): Delta images i.e. both after and before images will be fetched

will it recognize deleted record.?

I have sql server database as source database , do i need to enable at source database level any change data capture or change data tracking mechanism in it to capture delata by DBConnect mechanism.?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers