MDWT_AdventureWorksDW.AuditTableProcessing


Metadata hierarchy: MDWT_Adventure_Works_Demo ยป MDWT_AdventureWorksDW


Attributes in AuditTableProcessing

Column NameData TypeIs KeyShort description
TableProcessKeyintSurrogate primary key
PkgExecKeyintForeign key to AuditPkgExecution
TableNamevarcharTable name
ExtractRowCntintCount of rows extracted from the source
ExtractCheckValue1floatCheck value of ETL designer's choice, eg Sum(SalesAmt), upon extract
ExtractCheckValue2floatCheck value of ETL designer's choice, eg Max(SalesAmt), upon extract
InsertStdRowCntintCount of rows inserted into target using standard processing
InsertStdCheckValue1floatCheck value of ETL designer's choice, eg Sum(SalesAmt), upon standard insert
InsertStdCheckValue2floatCheck value of ETL designer's choice, eg Max(SalesAmt), upon standard insert
InsertNonstdRowCntintCount of rows inserted into target using a non-standard branch of the ETL system
InsertNonstdCheckValue1floatCheck value of ETL designer's choice, eg Sum(SalesAmt), upon non-standard insert
InsertNonstdCheckValue2floatCheck value of ETL designer's choice, eg Max(SalesAmt), upon non-standard insert
UpdateRowCntintCount of rows updated in target table
ErrorRowCntintCount of error rows not inserted into table
TableInitialRowCntintInitial row count of target table, pre-processing
TableFinalRowCntintFinal row count of target table, post processing
SuccessfulProcessingIndcharDid this table finish processing successfully?

Internal data warehouse auditing attributes

Column NameData Type