I am using cdc data as source data for my data vault. One of our sources returns deleted records without a previous existing insert.
In our hubs and links, there is a filter that excludes deleted records to be inserted in the link or hub. But the sattelite and link sat does allow the record, to have a trail.
What we have now is there are sattelite records without a hub record.
I am wondering if this is correct?