Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2005-01-06 : 03:53:38
|
| Hi,The approach that I am using is that I drop, create, and then populate all the tables in my DataMart. And after populating my tables, I am doing a full processing of allmy dimensions and then the cube.Given this approach and my understanding (so far), I am assuming that I need not define my dimension as changing.Can someone kindly confirm if I am using the right approach or whether I still should define my Dimensions as 'Changing Dimension'. If so, kindly help me understand the benefits of doing so.Thanks.Thanks & Regards.-J |
|
|
|
|
|
Should I define my dimensions as 'Changing'?