I am trying to figure out how to handle following situation.
I have a table in source system, which ends up as MAS in our system, let's call the table A, the related hub that is filled by it H_A and the related MAS sat as MAS_A. The table 'A' holds phone numbers of customers. One customer can have work or home phone number, that's why MAS.
Today, we have received another table, which tracks delete of records in the above mentioned table A. Let's call this table B.
How do I properly handle information coming from table B, which states, that only the "work" phone number was deleted, yet the "home" phone number stays in place? Which means I can't create link towards the H_A, but I'd need something like record tracking satellite which would be linked to the MAS_A? It's good to know once the record is deleted, it can't be recreated with the same ID in the source system. I know that sat-link-sat is not DV2.0 proper modelling solution and I don't know how to handle this properly.
