Help with removing synthetic keys

[stevejones1]

Hi

Can someone help me removing the synthetic keys from the attached data model ? I have 2 facts SPR and SPR Account , i have 2 dimensions Geo and TDM .. which has to be shared by both the facts.

Please help

Thanks!

[Gysbert_Wassenaar]

I doubt you need to remove that synthetic key for performance reasons. I reckon it'll be purely cosmetic.

See this blog post for more information: Synthetic Keys

[stevejones1]

But if i want to remove how do i remove ?

Link table ? canonical Dates?

what is the best option and why ?