Welcome to WebmasterWorld Guest from 34.238.192.150

Forum Moderators: open

Message Too Old, No Replies

OLAP design question

Where do you take care of dependencies?

     
4:50 pm on Sep 12, 2007 (gmt 0)

Full Member

10+ Year Member

joined:June 18, 2004
posts:327
votes: 0


Hi guys,

So I have a question:

if dbo.table.FactSales.[TotalAmount]

is dependant on dbo.table.DimProducts.[UnitPrice]

and if you happen to update the unit prices, where do you take care of [TotalAmount] being updated?

Thanks
Leo

PS: my question is for when the unit prices are wrong and you want to fix them.

6:45 pm on Sept 17, 2007 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12555
votes: 3


Often times dependencies are handled using database triggers. But in many cases, such as this one perhaps, you shouldn't even store totals that are dependent but calculate them "on the fly" as you retrieve the information from the database.