Forum Discussion
Syndicate_Admin
Administrator
3 years agoConvert 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
Administrator
3 years agoThanks 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?