Gazareth (10/9/2012) Jason-299789 (10/9/2012) Gazareth (10/9/2012)
Hmm, yeah. Was wondering that myself!
I think that Joe was probably refering to some form of regulatory requirement, eg Sarbanes Oxley/solvency II or other federal requirement to maintain data change history.
Ah yes. Luckily we're not all subject to American law... :-D
If you work in the finance industry in Europe we do have Solvency II regulations that have to be in place for 2013/14 (I believe) and one of those requirements is full audit trails of data changes, including data traceability through ETL into Data Warehouse's, especially if they are used as a source for regulatory reporting to bodies like the FSA, Lloyds etc.
_________________________________________________________________________SSC Guide to Posting and Best Practices