How to delete orphan but active records on source and instance table

Hi @sgilla, thanks for posting. Could you please explain further what’s the impact on your Ataccama platform tables, if any? When you are using different platforms as your primary source of data & records the initial documentation and resources taken as reference should be linked to the relative platform. 

I am not sure if I could explain. The records inactive at source but active on omnihealthdata do have impact on sources which use this master data from omnihealth. For example after a reprocess and omni modified date changes and hence the target sees the orphan records being updated. 

The design and planning for source to MDM omnihealthdata table and mastered data being utilized are all streamlined well and this should have been taken care during these steps and i believe the exceptions have been during a downtime or a db restores we had. I was wondering if its ok to directly clean up the source and instance tables on the db or could there be a downside. Thank you.

Thank you.