Datawarehouse design
The attribute value in Dimension table are going to change slowly over time and they are not going to be…