MDWT_AdventureWorksDW.DimAudit


Metadata hierarchy: MDWT_Adventure_Works_Demo ยป MDWT_AdventureWorksDW


Attributes in DimAudit

Column NameData TypeIs KeyShort description
AuditKeyintSurrogate primary key
TableProcessKeyintForeign key to AuditTableProcessing
BranchNamevarcharName supplied by the ETL developer for branch that adds / updates data in the target table
BranchRowCntintCount of rows added/updated in this package branch
ProcessingSummaryGroupvarcharWhen we summarize rowcounts in AuditTableProcessing, is this branch considered "standard" or "non-standard"?

Internal data warehouse auditing attributes

Column NameData Type