I need to add some slowly changing dimensions to a cube. What's the best way
to do this...through SSIS wizards or programmatically? I've read that ms
supports this programmatically but I've yet to find an example. Does anyone
have one in C# they could post?

thx,
-M

from a cube point of view, there is nothing to do.
you have to made the job at the ETL level and SSIS will help you for this
job.
generate surrogate keys and use them in the fact tables.
search on the web to find best practices for this.


"Marilyn" <Marilyn (AT) discussions (DOT) microsoft.com> wrote