hard20 pts · first answer countsdata-modellingscd

A product moved to a new category

A product moved from "Home" to "Kitchen" in June. Finance wants last year's category totals to stay as reported, but merchandising wants all history under today's category. What design serves both?

A.Type 2 history plus a current-category column on each rowB.Type 1 overwrite of the categoryC.Type 2 history only, with no current-category attributeD.Two separate warehouses, one built for each team

Discussion 0

Join free to post in the discussion.

A product moved to a new category

Discussion 0

Related questions