July 20, 2011 at 6:41 am
Hi All,
I have identified a few data quality issues via a Business Objects report. The db
is a sql 2005 db, I have been advised to delete the corrupt records from the entire db,
however I am just abit concerned about this. Apart from archiving what other options do I have?
Many Thanks
July 20, 2011 at 7:58 am
That really depends on your system. Do you have the ability to "soft delete" or mark records inactive. How are these records tied to other data? Will you be creating orphaned records?
There are just too many possibilities without knowing your setup.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:19 am
Thanks Jason,
what is soft delete?
It is a relational db....
How does orphan records work?
Many Thanks
July 20, 2011 at 8:24 am
A Soft Delete would be the case if your records had a column that defined the state of the record. i.e. an isActive bit column or an endDate column. Something that logically tells the application this record is "hidden" or deleted with respect to the end UI.
An orphaned record would be something like you have a state table with all 50 states listed, and a city table with all US cities. If you deleted the "Texas" state entry, then the "Houston" entry would be considered orphaned.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 20, 2011 at 8:26 am
Thanks Justin....
Will review all your listed options...
Many Thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply