Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Convert mademade table columns to dimension table.

Good I have an order table which has approximately 60 columns. Applying the concept of normalization / denormalization, what I intend is to separate the different columns into several dimension ...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Thanks for the reply. Regarding the comment of creating static dimension tables. The truth is that I would like that. Create static dimension tables. But in some cases the problem I'm going to have is that updating those dimension tables is going to come to me because of the fact table. For example: a new customer. I'll find out when I come through the fact table. So in this case the solution would be to create the dimension table through the duplicate of the facts right? Because this way I make sure that the dimension table is updated automatically. That's right?

  • DataVitalizer's avatar
    DataVitalizer
    Icon for Super User rankSuper User
    3 years ago

    To prevent the dimension tables from getting updated everytime the fact table does, you can uncheck 'Include in report refresh' for Dims, as I mentioned previously it depends on the frequency of having new values that should be added to the Dimension Table

    Another scenario would be creating dataflows to have the ability of configuring independent refreshes for your different tables and the refresh will run cloud-side.


    Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
    Was this exchange helpful? A kudos 👍 would be appreciated