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,
I have several fact and dim tables and there is a link existing in between my fact tables.
Is it better to connect the fact table through their link and 1 fact table to the dim tables ?
Or is it better to connect all Fact table to all dim tables ?
See the old school model below 🙂
Consolidated fact table is definitely not recommended as explained in the videos below from Guy In a Cube.
Hello @CapucineBenier ,
If the fact tables have the same columns and can be one table, it's better to combine all the fact tables in one table and then connect this table to the dimensions, else if this is not posssible then connect every fact table to all the dimensions.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Proud to be a Super User! | |
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
63 | |
61 |