# How to do 100% insert only soft delete? (Record Source Tracking)

**URL:** <https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513>\
**Category:** Data Vault 2.0\
**Created:** [November 21, 2022, 9:00am UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513 "2022-11-21T09:00:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sosmaf](https://avatars.discourse-cdn.com/v4/letter/s/ed8c4c/32.png) [@sosmaf](https://forum.data-community.org/u/sosmaf)\
**Post date:** [November 21, 2022, 9:00am UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513/1 "2022-11-21T09:00:43Z")

</div>

Let’s say we need to soft delete business keys that do not appear for 4 consequent weeks in the source and we use a some sort of “Deleted Status Satellite”.  
How can we mark the status of the keys that do not appear in the feed by using inserts only? And avoiding all sorts of scans.

---

<div class="post-metadata">

**Author:** ![AHenning](https://avatars.discourse-cdn.com/v4/letter/a/96bed5/32.png) [@AHenning](https://forum.data-community.org/u/AHenning)\
**Post date:** [November 21, 2022, 6:16pm UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513/2 "2022-11-21T18:16:05Z")

</div>

Hello!  
Use a record tracking satellite, RTS.  
Google how they work. Good luck!

---

<div class="post-metadata">

**Author:** ![neil.strange](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/neil.strange/32/407_2.png) [@neil.strange](https://forum.data-community.org/u/neil.strange)\
**Post date:** [November 22, 2022, 9:24am UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513/3 "2022-11-22T09:24:22Z")

</div>

You should use a record tracking satellite. This contains metadata that records each time a business key is fed to the Vault. This is covered in the Building a Scalable Data Warehouse with Data Vault 2.0 book.

---

<div class="post-metadata">

**Author:** ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\
**Post date:** [November 24, 2022, 10:36pm UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513/4 "2022-11-24T22:36:15Z")

</div>

**Option 1** : get the source to send you a flag  
**Option 2** : If the source is a snapshot, infer the delete with a Status Tracking Satellite  
**Option 3** : You can infer the soft delete by the last time a business key appears using a Record Tracking Satellite and then populate a Business Vault Status Tracking Satellite (you’re defining a business rule), BUT, do you need an RTS to infer something you can simply get from an adjacent satellite around a hub? I’m into having fewer tables not more.

---

<div class="post-metadata">

**Author:** ![RhysHanscombe](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/rhyshanscombe/32/394_2.png) [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\
**Post date:** [December 1, 2025, 2:44pm UTC](https://forum.data-community.org/t/how-to-do-100-insert-only-soft-delete-record-source-tracking/513/5 "2025-12-01T14:44:33Z")

</div>

Closed on December 1, 2025, 2:44pm UTC


