easy5 pts · first answer countsdata-warehousingscd

Slowly changing dimension type 1

A customer moves from Pune to Bengaluru. The customer dimension is SCD type 1. What happens to the row?

A.A new row is added and the old one is closedB.The city is overwritten, so history is lostC.A column previous_city is addedD.The row is deleted

Discussion 0

Join free to post in the discussion.