Lulutho Mgwali Lulutho Mgwali - 10 months ago 55
SQL Question

Slowly Changing Dimension Type 1 - access

Say I have a product table which contains a descriptions mistake. The unit of measurement was misspelled as “garms” instead of “grams”. How would this be implemented with a query statement to represent type 1 - SCD technique.

Answer Source

I managed to get an answer for this question. I was looking for something like this:


SELECT all from Product Table
UPDATE Product Table
   SET [Product Unit of Measure] = “grams”
   WHERE [Product Unit of Measure] = “garms”