help with dupicated values in dimension and facts

• Sachin4all

  Ten Centuries

  Points: 1249

  More actions

  June 30, 2011 at 3:03 pm

  #252937

  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

• sam.dahl

  Hall of Fame

  Points: 3112

  More actions

  June 30, 2011 at 6:06 pm

  #1346820

  This is a duplicate post.

  See reply here: http://qa.sqlservercentral.com/Forums/Topic1134716-391-1.aspx