Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Using MERGE for Audting Expand / Collapse
Author
Message
Posted Tuesday, October 9, 2012 3:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 2,114, Visits: 3,720
terry999 (10/2/2012)
illegal?


Hmm, yeah. Was wondering that myself!
Post #1370255
Posted Tuesday, October 9, 2012 3:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 955, Visits: 2,638
Gazareth (10/9/2012)
terry999 (10/2/2012)
illegal?


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.

Who knows.....


_________________________________________________________________________
SSC Guide to Posting and Best Practices
Post #1370270
Posted Tuesday, October 9, 2012 4:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 2,114, Visits: 3,720
Jason-299789 (10/9/2012)
Gazareth (10/9/2012)
terry999 (10/2/2012)
illegal?


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.

Who knows.....


Ah yes. Luckily we're not all subject to American law...
Post #1370278
Posted Tuesday, October 9, 2012 4:16 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:28 AM
Points: 955, Visits: 2,638
Gazareth (10/9/2012)
Jason-299789 (10/9/2012)
Gazareth (10/9/2012)
terry999 (10/2/2012)
illegal?


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.

Who knows.....


Ah yes. Luckily we're not all subject to American law...


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
Post #1370285
Posted Tuesday, October 9, 2012 4:30 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:35 AM
Points: 2,114, Visits: 3,720
Jason-299789 (10/9/2012)
Gazareth (10/9/2012)
Jason-299789 (10/9/2012)
Gazareth (10/9/2012)
terry999 (10/2/2012)
illegal?


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.

Who knows.....


Ah yes. Luckily we're not all subject to American law...


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.


Fair enough
Post #1370294
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse