How to delete orphan but active records on source and instance table in Omnihealthdata. The records were deleted at source but the load to onramp was missed for delete batch. Is there other way I could delete these records from _s(source) and instance tables? Is a manual SQL delete a right way to go with or would it cause any future issues?
Best answer by Cansu
View original
+7
Hi
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.
+7
Hi
Thank you.
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
