Generic Audit Trail for Fact Tables in a Database
In some cases, I just don’t like the field-by-field logging when creating an audit trail for my database tables. While it might be needed in some cases (and it might make sense), most of the time, I am find that a simple audit table that stores an entire record of fact data is more useful and easier to manage for reporting, etc.
So, instead of a generic audit table that captures all old and new values for many tables, I prefer creating an audit table for each of my important fact tables. Drop me a line if you are struggling with how to implement auditing (on Oracle, SQL Server, or MySQL) and we can chat.