You can translate the question and the replies:

time dimension table

my fact table contain two field of time one for the creation and the other for the shiping how i can create the time dimension tible in denodo ?
23-01-2023 16:08:34 -0500

1 Answer

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]( and [How to Model Slowly Changing Dimensions in Denodo]( 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]( in the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
26-01-2023 21:10:03 -0500
You must sign in to add an answer. If you do not have an account, you can register here