Audit Dimension Doubt

View previous topic View next topic Go down

Audit Dimension Doubt

Post  caladsantiago on Thu Dec 22, 2011 12:54 pm

I'm currently studying the datawarehouse theory along with one of my friends from Kimball group's books and we're stuck at the part
where they talk about the audit dimension.
We understand that most of the fact records point to a single row in the audit dimension which represents a clean run for the whole ETL
process. However, we're not sure about the number of generated rows when we find errors during this process since the severity score on
each screen is an arbitrary number and each row might have a different total screen category score (which would be logged into the
audit dimension as completeness, validation, or out of bounds score).

We've had some ideas, like adding up the severity score for all the rows which had only validation errors, all which had only completeness
errors and all which had both kinds of errors and generate at most four rows per ETL run, but we're not sure if we're misunderstanding what
the book states about those values.

caladsantiago

Posts : 3
Join date : 2011-12-22
Age : 29
Location : Medellín-Colombia

View user profile

Back to top Go down

Re: Audit Dimension Doubt

Post  BoxesAndLines on Thu Dec 22, 2011 4:10 pm

It is a little confusing. Try this article and see if it helps.
Architecture for Data Quality
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

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