Skip to Content
Former Member
Feb 05, 2016 at 05:37 AM

Skip DELETE in HANA but update the records with a 'D' flag



I wanted to SKIP the delete operation in the source to be replicated to HANA but at the same time, want the record in HANA to be updated with a 'D' flag (to identify that the record has been deleted in source).

I followed the blog which solves only the first part of my requirement.

So, what I did is, instead of skipping the record, I changed the operation flag to 'U' so that the delete is converted to an update in HANA with the additional field specifying the delete flag.

But the flip side to this is, though the record is not getting deleted in HANA and has the flag updated, it also updates all non-key values with defaults !!! Which is not helping as I am losing data 😔

Any inputs are appreciated.




SLT.jpg (100.0 kB)