Author Topic: Will one DC support multipal Fact_Table?  (Read 23211 times)

Offline Eag. E

  • Community Leader
  • *****
  • Join Date: Feb 2014
  • Posts: 77
  • Forum Citizenship: +0/-0
Will one DC support multipal Fact_Table?
« on: 21 Nov 2019 10:09:22 pm »
As our Fact Table is big, we have separated the fact table into sevral smaller ones, such as FT_SALES_2018, FT_SALES_2019 ... They are all same in DDL structure, but I found CA DC only support star schema, looks like can not have several Fact Table

Thanks

Online bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 480
  • Forum Citizenship: +45/-0
Re: Will one DC support multipal Fact_Table?
« Reply #1 on: 22 Nov 2019 03:37:29 am »
Look up about virtual cubes.

Each cube can only support one fact table but virtual cubes allow you to have a multi-fact cube.

http://www.redbooks.ibm.com/abstracts/sg248064.html?Open

Offline Eag. E

  • Community Leader
  • *****
  • Join Date: Feb 2014
  • Posts: 77
  • Forum Citizenship: +0/-0
Re: Will one DC support multipal Fact_Table?
« Reply #2 on: 23 Nov 2019 08:25:00 pm »
Thanks so much, it helps a lot, by the way, I saw the book was in 2015, is there any new version of this book? Or the DC has stopped developing

Online bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 480
  • Forum Citizenship: +45/-0
Re: Will one DC support multipal Fact_Table?
« Reply #3 on: 24 Nov 2019 05:23:23 am »
I have not seen any new edition of the Redbook nor have I seen much, if any, changes in the UI of cube designer or of dynamic cube behaviour.   

Neither of those are particularly pertinent to your immediate problem, which is how to deal with multiple fact tables.