Data Modeling for Bigquery

[Yrstruly2021]

 

Would you please advise, how would you denormalise such a data model as this one?

Client journey and Mapping table can be brought into CM Data as it already contains it. Zip code can be linked to store location, just can't seem to link store location to my fact table which is CM Data.

In my mind i will make 5 tables to 3 tables, please advise?

Thank you in advance.

[v-yanjiang-msft]

Hi @Yrstruly2021 ，

Your screenshot is not clear, can you provide it again?

Best Regards,
Community Support Team _ kalyj