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

Audit Dimension Doubt

Go down

Audit Dimension Doubt Empty Audit Dimension Doubt

Post  caladsantiago 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 : 32
Location : Medellín-Colombia

Back to top Go down

Audit Dimension Doubt Empty Re: Audit Dimension Doubt

Post  BoxesAndLines Thu Dec 22, 2011 4:10 pm

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

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

Back to top Go down

Back to top


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