Hello, I’m working on the extraction of data on CARE_SITE. I have a question on this, should I keep the history of the care site? If so, where should I store this information?
In my data source, the information on the care site is updated: some care site names have been changed, some care sites no longer exist. However, these obsolete data may be related to other data. If I keep only the most recent version of the care sites, I can not guarantee the consistency of data.
Do you have any ideas for this problem? Thank you.