• SQL Noob (7/8/2009)


    how is this different than the standard audit tables that record changes?

    a) it is allowed to gather additional data via XML

    b) it is extended to the way that you can record only row changes instead of complete changes (may be for differential load)

    c) It shows you not only the audit but how translate audit into something useful, for example to find which products are changed for differential load while you don't need to know exact changes.

    At least those points in addition to my previous article where one of the point is the use of ROW_ID instead of complex primary key values.