AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension
Page 1 of 1
AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension
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?
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
Similar topics
» Best Practices for SCD Dimension Tables for a Banking Data Warehouse
» Model available time per day in timesheet data warehouse: fact or dimension or neither?
» The great SQL query "template" from edition 1 of Data Warehouse Toolkit
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
» Model available time per day in timesheet data warehouse: fact or dimension or neither?
» The great SQL query "template" from edition 1 of Data Warehouse Toolkit
» data warehouse or not ? when is it okay to use OLAP without a data warehouse database
» Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum