Hi,
You can connect fact tables to dimensions by applying joins between your fact table and the dimensions. It would also be helpful to create associations between the fact and dimension tables to establish relationships and reduce redundancy between joins. You can refer to the [Associations in Denodo](https://community.denodo.com/kb/en/view/document/Associations%20in%20Denodo) and [How to Model Slowly Changing Dimensions in Denodo](https://community.denodo.com/kb/en/view/document/How%20to%20model%20slowly%20changing%20dimensions%20in%20Denodo) articles in the Knowledge Base for more information.
An alternative would be to make a Denodo connection to a multidimensional database. This will allow a dedicated source to merge the tables. Denodo has a built-in data source wrapper for multidimensional databases. You can refer to [Multidimensional Database Sources](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/creating_data_sources_and_base_views/multidimensional_database_sources/multidimensional_database_sources) in the Virtual DataPort Administration Guide for more information.
Hope this helps!
