The Customer detail information is loaded into ODS and InfoCube.
One of the requirement is to keep track the old historical data... example, if the customer address has been changed, we should
be able to keep track the old address information, and display it in the report.
The address is store in Characteristic, when the data is loaded into ODS, the old address will be overwritten.
Question is how we can prevent this so that the old address will be kept, and display in report?
I guess this is more on design solution rather than technical issue.
Please advice, thank you.