AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension

View previous topic View next topic Go down

AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension

Post  DavidStein on Sat Feb 26, 2011 11:36 am

In this book, the authors recommend 3 tables for an auditing.

AuditPkgExecution
AuditTableProcessing
AuditDimension

The second table gets a new row for each table that is manipulated in a package. It consists of columns like ExtractRowCount, InsertStndRowCnt, UpdateRowCnt, etc.

However, if I am splitting my process into phases like Extract, Transform, and Load with staging between them, what exactly is my TableName?

I think that it would be the Source Table Name for the Extract, Staging Source Table Name for the Transform, and the Destination Table for the Load.

However, if I do that, how do I tie all of my records together to verify that I've accounted for every row extracted in some way?


DavidStein

Posts : 24
Join date : 2010-04-01

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum