Home » Developer & Programmer » Designer » Fact Table Design (Oracle)
Fact Table Design [message #581791] Wed, 10 April 2013 15:00
sbatlanki
Messages: 1
Registered: April 2013
Location: Boston
Junior Member
Hi,
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.

Thanks
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: Fri Aug 01 04:21:43 CDT 2014

Total time taken to generate the page: 0.05843 seconds