The most common of all dimensions is time, since there is virtually no reporting or analysis done without the context of when. A time or calendar dimension can always be derived of source data, as any other dimension. Additionally you can also take advantage of the time table and time dimension features in tX2012 to…
> Dimensional ModelingSlowly Changing Dimensions
Slowly changing dimensions type 1 and 2 is a key to Kimball style dimensional modeling and is of course supported in tX2012 with an easy to use interface, that allows implementation within minutes – without any SQL knowledge required. The tX2012 implementation further includes the use of hashed values for better performance on large dimensions.…