help with dupicated values in dimension and facts

• Sachin4all

  Ten Centuries

  Points: 1249

  More actions

  June 30, 2011 at 3:00 pm

  #240213

  I have a situation in DWH where one of the dimension is not loading properly which is product dimension.

  The product dimension data comes from four oltp databases.so data which is coming

  from one of the oltp databases is creating a new record instead of doing a update for the already existing record.

  So for a same product id there are duplicates.

  the dimension is related to 6 different fact tables.

  Now i need the remove the duplicated dimension values in the dimension table

  and update the correct productid in the facttable

• Paul White

  SSC Guru

  Points: 150457

  More actions

  June 30, 2011 at 11:38 pm

  #1346869

  I doubt you will receive many useful replies to your question unless you can provide something more concrete for people to work with.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi