Forum Discussion
Data Modeling - Customers
Hi,Anonymous .I am glad to help you.
According to your description, you are having some problems designing your data model.
Although I'm not very good at data model design, I'd like to help you out
I think you can create a separate table specifically to record dynamic attribute changes for customers.
like this:
|
ATTRIBUTE_ID |
CUSTOMER_ID |
ATTRIBUTE_NAME |
ATTRIBUTE_VALUE |
DATE_FROM |
DATE_TO |
|
1 |
200142025 |
Marketing Consent |
YES |
2024-05-31 |
2024-08-15 |
|
2 |
200142025 |
Marketing Consent |
NO |
2024-08-15 |
NULL |
The table is associated with your existing table through the CUSTOMER_ID field to your existing table.
You can use join query (left outer join/right outer join) to fetch the user's consolidated data
Note that this is only my suggestion to you, you need to build the appropriate data model according to your actual situation.
I hope the following information can help you.
URL:Dimensional Modeling Techniques - Kimball Group
A Guide to Data Modeling & The Different Types of Models | Twilio Segment
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello! Thank you for the suggestion. I think I will also add a FCT table that will connect the date dimension to the customers dimension and mini dimension.
Like this: