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

Handling History tables in Dimensional Model

2 posters

Go down

Handling History tables in Dimensional Model Empty Handling History tables in Dimensional Model

Post  kellog1 Sat Dec 19, 2009 6:40 pm

Gurus,
We are designing dimensional model for our organization. In our current OLTP system we have base tables and history tables. The table structure of history tables is mirror of base tables with addition of 3 auditing columns (Transaction Type, Transaction User and Transaction Date). So I am wondering what should be our design approach. Does anyone have any thoughts on this? Thanks

Here is the sample table structure…

Base Table Structure:
BaseId (PK)
HistId (FK)
Col3
Col4

History Table Structure:
HistId (PK)
BaseId
Col3
Col4
TransactionType
TransactionUser
TransactionApp
TransactionUtc

kellog1

Posts : 4
Join date : 2009-12-19

Back to top Go down

Handling History tables in Dimensional Model Empty Re: Handling History tables in Dimensional Model

Post  BoxesAndLines Sun Dec 20, 2009 3:01 pm

Why do you have a HIST_ID FK in the base table? A general answer to your question is that all history is represented in the fact table.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Back to top

- Similar topics

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