Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In query editor I have created dimension table from sales fact table using reference table option. When I deleted a column in sales fact table which was also present in dimension table, it causes an error in dimension table as it was taking that column (deleted one) from sales fact table. So is it means that we should use duplicate table option instead of reference table option while creating dimension table? What is the best practice , use duplicate table option of reference table option?
Solved! Go to Solution.
Hello,
in your case it is best to use duplicate query cos you need to create a dimension table using your source fact table as ref
Did I answer you Question? Do not forget to mark it as solution!
Hello,
in your case it is best to use duplicate query cos you need to create a dimension table using your source fact table as ref
Did I answer you Question? Do not forget to mark it as solution!
Thanks
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |