Skip to Content
0
Feb 27, 2009 at 05:05 AM

keep old history info

34 Views

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.