Will one DC support multipal Fact_Table?

[Eag. E]

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

[bus_pass_man]

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

[Eag. E]

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

[bus_pass_man]

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.