Synthetic Key

[M_J]

Hi,

I am trying to add an excel workbook to the existing data model with two different columns ( 1. Category and 2. Months).

As we expected it creates a synthetic key. How do I resolve this synthetic key in this case?

Thanks

[Lisa_P]

Can you give us a snapshot of your data model ?

[M_J]

Hi Lisa,

I apologize for the late response. Since the data model is for the company I can not give you the actual data model.

Here I have attached the similar model.