Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension

Go down

AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension Empty AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension

Post  DavidStein 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

Back to top Go down

Back to top

- Similar topics

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