Star Schema

[HumzaIftikhar]

Hi, i have encountered a situation while developing a star schema. my table looks like this

amy	amy@hotmail.com
jess	amy@hotmail.com
lee	abc@gmail.com
lee	xyz@gmail.com

i am trying to develop my dimensional table but facing this duplication. is there any idea to fix this situation to avoid duplication while populating and fethcing the results. 

your help will highly regarded. 

[v-shex-msft · Accepted solution]

Hi @HumzaIftikhar,

Did you mean your table includes some duplicate records with the same keys? If that is the case, you can extract these duplicate keys to create a new table with unique values as a bridge to link the raw table and the fact table with these keys.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

If the above does not help, can you please share some more detailed information to help us clarify your scenario?

How to Get Your Question Answered Quickly 

Regards,
Xiaoxin Sheng