Design the dimension table for the following scenario
ABC Company had planned to maintain complete customer information with following guidelines
1. Changes In the customer address to be maintained historically.
2. Only last two changes on customer telephone number – to be tracked. Example: If customer changes the number from 001 to 002 then we should have details as following CURR_TEL_NUMBER (002) PREV_TEL_NUMBER (001)
3. Customer details like (Marital status column should be overwritten)
4. Name, DOB column will be inserted only once and there will be no updates for the same