SCD 2 Audit / Metadata Columns
2 posters
Page 1 of 1
SCD 2 Audit / Metadata Columns
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
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
Re: SCD 2 Audit / Metadata Columns
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.
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- Posts : 1212
Join date : 2009-02-03
Location : USA
audit columns
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
Similar topics
» How many columns is too many OR how to reduce the columns
» Data Vault v's Dimensional Model
» metadata driven ETL architecture
» metadata management
» Modeling tool with support for hierarchies
» Data Vault v's Dimensional Model
» metadata driven ETL architecture
» metadata management
» Modeling tool with support for hierarchies
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum