How to handle customer name changes in databases?

Viewed 44

I am redesigning our data warehouse to utilize a star schema and I see instances of customers where they are Jane Doe and get married and now are Jane Smith. The issue is I have to tie all of their data to their customer ID, what is the best way to handle this?

0 Answers
Related