Groups > comp.databases.ms-sqlserver > #1888

How to keep a history of price for different ice cream in a dataware house

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	How to keep a history of price for different ice cream in a dataware house
Date	2015-02-15 18:02 +0100
Organization	A noiseless patient Spider
Message-ID	<mbqjdu$32o$1@dont-email.me> (permalink)

Show all headers | View raw

Hello!

Assume I have a table called Sales in the dataware house where we have the 
four columns Month, Ice cream, City and quantity.
We have three dimensions where we have Month, Ice cream and City.
It could look like this
Sales table
Month        Ice cream        City                Quantity
January      Päronsplitt        Stockhomn       3
January      Top hat            Göteborg           7
January       Smugler           Malmö              13


Now to my question. It is important to keep historic data in the dataware 
house.
So assume that I want to keep history of the price that have been existing 
on different ice cream how
would this be structured in the sales table.

//Tony

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

How to keep a history of price for different ice cream in a dataware house "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-15 18:02 +0100
  Re: How to keep a history of price for different ice cream in a dataware house Erland Sommarskog <esquel@sommarskog.se> - 2015-02-15 19:58 +0100
    Re: How to keep a history of price for different ice cream in a dataware house "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-15 21:38 +0100
      Re: How to keep a history of price for different ice cream in a dataware house Erland Sommarskog <esquel@sommarskog.se> - 2015-02-15 22:14 +0100
      Re: How to keep a history of price for different ice cream in a dataware house "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-15 22:30 +0100
  Re: How to keep a history of price for different ice cream in a dataware house rja.carnegie@gmail.com - 2015-02-16 03:51 -0800
  Re: How to keep a history of price for different ice cream in a dataware house --CELKO-- <jcelko212@earthlink.net> - 2015-02-16 08:37 -0800
  Re: How to keep a history of price for different ice cream in a dataware house gposta10@gmail.com - 2015-03-23 11:44 -0700

csiph-web