I have a question related to the best approach for loading data into a slowly changing dimension with start and end dates. We need to load into a end user dimension from OLTP. The data for this dimension comes from multiple source say for example person details, person email details, person status and person address. All these source are stored as separate tables in OLTP and we now to merge all this information into a single dimension with valid start and end dates for each of the dimesion row. What would be the best approach to achieve this?
Seehttp://download.microsoft.com/downl...-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc is any help. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.