Skip to Content
0

Delta Load In DBConnect in BW 7.3

Nov 26, 2016 at 01:57 AM

36

avatar image

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.?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers