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

SCD 2 Audit / Metadata Columns

2 posters

Go down

SCD 2 Audit / Metadata Columns Empty SCD 2 Audit / Metadata Columns

Post  kvenkatr Thu Jul 09, 2009 1:27 am

What are the standard audit columns / meta data columns that you will create in a SCD 2 Dimension table.

potentially we will get more than one data feed from the same vendor for any given day and we need to track the versions / historical changes to the data .

In a typical SCD2 table, besides the business data columns, PK/Sk, what other standard collumns that you would create ?

Thanks
venkat

kvenkatr

Posts : 2
Join date : 2009-07-09

Back to top Go down

SCD 2 Audit / Metadata Columns Empty Re: SCD 2 Audit / Metadata Columns

Post  BoxesAndLines Thu Jul 09, 2009 11:47 pm

system add date, system modify date (date rows were added or modified)
load audit id, modify audit id (ETL audit identifier to identify which ETL process loaded or modified the data)

I put all of these on fact rows too except for the modify audit id unless it is an accumulating snapshot fact.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

SCD 2 Audit / Metadata Columns Empty audit columns

Post  kvenkatr Fri Jul 10, 2009 12:26 am

Can you pls give an example of a type-2 dimension table and fact table with all the audit columns you would include

kvenkatr

Posts : 2
Join date : 2009-07-09

Back to top Go down

SCD 2 Audit / Metadata Columns Empty Re: SCD 2 Audit / Metadata Columns

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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