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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Oct 03 16:09:28 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.