Reference Table Or Duplicate Table

[NaeemShahzad123]

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?

[CharbelArmaleh · Accepted 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!

[NaeemShahzad123]

Thanks