Records Limit for DIM Table
답변함Hi,
I have a DIM table which have total no of records around 3.5 millions and the limitation of DIM Table is 2 millions, so in case I upload the table as fact table and use in my queries will there be any issues.
Is there any other workaround as how I can upload the DIM Table records into workiva.
Thanks & Regards,
Dipti Khandelwal
-
Hi Dipti,
The primary difference between the FACT and DIM tables, other than the row limitation you noted, is the ability on a DIM table to specify a primary key. Primary keys are useful for ensuring that there is uniqueness. If that is not a concern, there is no technical reason why you can't load dimension type information to a fact table.
That said, I would be interested to hear more about how you intended to use such a large dim table. We have seen instances where using dim tables in a manner that is not well suited for Wdata results in suboptimal performance. Would you be able to share a little bit more of your use case so that we can better understand and offer you some additional options to consider?
Thanks,
Tony
0
Hi Tony,
The DIM table will be used just to pull some columns data into our query as the outcome will be based on those specific results, even wanted to check what can be the possible ways to handle such large data sets for DIM Tables can we pull in data by adding some conditions in our chains?
Another factor which I wanted to check is is it possible to add 2 fact table- in one query to have the expected outcome.
Thanks & Regards,
Dipti
0댓글을 남기려면 로그인하세요.
댓글
댓글 2개