Audit dimension for a dimension?

View previous topic View next topic Go down

Audit dimension for a dimension?

Post  kskistad on Thu Feb 18, 2010 7:04 pm

The books describe how to create a useful audit dimension for the fact table rows, but what about the dimension table rows? Why isn't that mentioned in the books? Isn't the data quality and lineage also important for dimensions?

Would you create a Audit dimension outrigger with a foreign key in the associated dimension table? Would this be the same Audit dimension as the fact table audit dimension, so all data is in one table?

Or would you simply add audit fields to each of your dimension tables and keep it there? The downside to that is the data is all over the place and would have to be collected or union'd to get a global picture?

kskistad

Posts : 11
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Audit dimension for a dimension?

Post  BoxesAndLines on Wed Feb 24, 2010 10:47 pm

Kimball has a more comprehensive Error event fact table for handling errors and transformation enrichment (e.g. address cleansing). Here's a link, Data Quality Architecture
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Audit dimension for a dimension?

Post  Joy on Wed Dec 01, 2010 5:12 pm

Yikes! The 2008 SSIS packages used to be up on the book's website, but I don't see them there now. I'll get them up there and post here when they're available. Expect them in a day or two. Sorry about that.

The 2008 version of the packages don't match the originals. Instead, they implement better practices. The audit dimension is one place they differ... the new version (which I can hardly call "new" any more) is even simpler than the version described in the 2005 book. My goal for the design of this audit dimension is to set the bar so low that you can have no excuse to not implement some sort of auditing. Clearly nowhere near as comprehensive as the version described in Ralph's article referenced in the previous post, nor other auditing and data quality screening described in The Data Warehouse ETL Toolkit.
avatar
Joy

Posts : 20
Join date : 2009-02-03
Location : Kimball Group

View user profile http://www.kimballgroup.com

Back to top Go down

Re: Audit dimension for a dimension?

Post  Sponsored content


Sponsored content


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