Forum Discussion
Resources Exceeded Error
Hello @EsraaKamal, @rohit1991, @srlabhe and Anonymous,
I appreciate how quickly you responded and provided a solution.
I tried every solution, but none of them were able to fix the problem. This is because the problem with my data set was different. Two date tables that I was using had non-continuous dates. The data load issue was resolved after those tables were removed.
Again, thank you very much for your support, everyone.
Regards,
Surekha
But how you do denormalize
Option1: Instead of having Category A, C, and D as separate tables, combine them into one (Append Queries). And ensure to have a column in this unified table called "Category" or "Type" so you we can distinguish between them in visuals.
Option2: Can merge some of dimension fields (like City Name) directly into your Fact table. This allows you to delete the relationship lines entirely as it removes the join overhead.
I hope now its clear for you Safaa