クラシックファイルタイプは、2021年1月をもって使用不可となりました。クラシックファイルを移行するか、PDFをダウンロードすることができます。 詳細を見る

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 

1

コメント

2件のコメント

日付 投票
  • Tony Scalese

    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
  • Dipti Khandelwal
    • 編集済み

    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

サインインしてコメントを残してください。