Forum Discussion
Reference Table Or Duplicate Table
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?
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!
2 Replies
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
