what are slowly changing dimensions? how do we create them?

system · December 8, 2004, 12:27pm

raovala (BOB member since 2004-11-01)

system · December 8, 2004, 12:45pm

I think this url will help you further in your quest for knowledge…
http://www.dmreview.com/article_sub.cfm?articleId=2998

jobjoris (BOB member since 2004-06-30)

system · November 13, 2009, 6:55pm

I found this blog very helpful for this topic, especially if you are on SQL Server.

nabila (BOB member since 2008-01-28)

system · November 14, 2009, 9:17am

See this post of mine, please.
As for creating so called SCDs (slowly changing dimensions), this has to be done as part of your ETL process.

You should also look at Ralph Kimball’s website here

Andreas (BOB member since 2002-06-20)

system · November 14, 2009, 7:59pm

I would suggest you to look on http://www.1keydata.com/datawarehousing/datawarehouse.html to get more on datawarehousing concepts.

Regards
Siva.M

looksmee (BOB member since 2006-02-08)