Loading Dimension Data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Loading Dimension Data

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
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.