SQL Server Performance

Loading Dimension Data

Discussion in 'Analysis Services/Data Warehousing' started by mbharathy, Feb 2, 2007.

  1. mbharathy New Member

    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?
  2. satya Moderator

Share This Page