Home » Developer & Programmer » Designer » Fact Table Design (Oracle)
Fact Table Design [message #581791] Wed, 10 April 2013 15:00
Messages: 1
Registered: April 2013
Location: Boston
Junior Member
Can we have Effective_start_date and Effective_end_date in a Fact table to track history?

In my scenario, the source doesn't maintain history, but the target needs to maintain history.

Please suggest if there is a better way to model it.

Previous Topic: Doubt in database design
Next Topic: I took an example ERD,but ask if what I found in it there is a flaw
Goto Forum:

Current Time: Tue May 21 15:08:08 CDT 2024