Lulutho Mgwali Lulutho Mgwali - 1 year ago 71
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”

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download