Sunday, 3 March 2013

Audit Columns in Datawarehouse

In data warehouse and data marts we maintain timestamp columns like “Last_Modified_Date or Created_Date” to track the exact date and time when the records were updated or inserted.These columns are called Audit Columns. But audit columns won’t track the deletion of columns. Last modified date stores the timestamp for record when it was modified for the last time and Created date will store the timestamp for the date on which the record was created, mostly we give it as SYSDATE

After we load the data for a particular day we can easily identify these newly loaded records by using audit columns. Whenever a record is inserted or deleted it makes a fresh timestamp entry through the Audit columns. So make sure that you include the Audit columns.


  1. It was informative post.I think it's helpful for me & all.Thanks for sharing and keep in blogging... CFA Audit | Stock Audit | Visibility Audit

  2. This comment has been removed by the author.

  3. Good job in presenting the correct content with the clear explanation. The content looks real with valid information. Good Work Continuous Transaction Monitoring
    Duplicate Payment Review
    Duplicate Payment Recovery
    AP Vendor Helpdesk

  4. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    internal audit services in dubai


Related Posts Plugin for WordPress, Blogger...