Hi there,
I would like to listen to your suggestions about how I can design the tables if:
- I want to store Forecast and Actual values
- I don't need to track who makes the changes, because it will be the application.
- There will be data or several values for the same entity. Those records, some of them can be active and the rest will be put in quarantine and after a while, transfer to the archive.
Thank you for your answer in advance.
Regards,
Alvaro.