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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!