SCD 2 Audit / Metadata Columns

View previous topic View next topic Go down

SCD 2 Audit / Metadata Columns

Post  kvenkatr on 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

View user profile

Back to top Go down

Re: SCD 2 Audit / Metadata Columns

Post  BoxesAndLines on 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.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

audit columns

Post  kvenkatr on 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

View user profile

Back to top Go down

Re: SCD 2 Audit / Metadata Columns

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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