Should I define my dimensions as 'Changing'?
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.