I designed a datawarehouse that contains only current patient data (i.e. if some data is modified for a patient, the "new" data overwrites the "old" data) in the datawarehouse. This works fine, but the customer wants to have any historical data in addition to the current data in the warehouse.
Do I need to build a separate warehouse that will contain historical data? What are the design considerations in such a case?
I would be glad if someone can you point me some articles or books that can help me.