Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, good afternoon,
I am very new in DataWareHouse, please can yo give me advice,
I have a fact table from a select where i have got two rows, one raw by any incident, which columns than identify the caseid and the productid which has produced the incident, one product has generated two incidents.
The problem is when i select a query than returns me by any incident the id of the email that the user sent to communicate the incident.
Of course i have my DimensionMail, which a primary key that is the id of the email and a column that is the email, of course is a varchar colum, buit i am a little confused with the results, i mean the number of rows in the 2 fact tables.
Please have a look at the squema, i thin is correct, buy i would like your opinions.
Thanks a lot
Hi @JavierM,
As above question is more related to DataWareHouse, you'd better contact with DataWareHouse support team to get more professional advice.
Regards,
Yuliana Gu