We define our datastores to hold 1 months data – we then create multiple datastores for history
For example
Datastor – live
Datasth1 – previous month
Datasth2 – 2 months back
Datasth3 – 3 months back
Each month we do the following:
Rename sth3 datasets to temp
Rename sth2 datasets to sth3
Rename sth1 Datasets to sth2
Rename temp datasets to sth1
Then use detector copy to copy live to sth1
Our performance team runs daily extracts to look for anomalies, and when needed, pulls data from the “archives”
This seems to have worked for us
Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266