python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Is it ok to have 2 dimensions that are the same but one is less deep?
I have a fact table, with account number and some numbers associated..
I have my DimAccount which has a very long hierarchy of level1,sub-level2… up to sub-level20.
When reporting in PowerBI this make...

Chicago1988
Votes: 0
Answers: 1
Data Model for different source data structures
Question on Data Modeling
I am building a data warehouse on Redshift where I have fact data coming from multiple sources.
Source 1 -
Has different facts and Dimension tables they are maintained well w...
Avi
Votes: 0
Answers: 1
Convert Data Vault model into Dimension Modelling
In my project I am using Data Vault 2.0 modelling. Now I wanted to build a dimension modelling from the Data Vault model (as per client request). Also we have CDC logic implemented in Data Vault and s...
Jomy
Votes: 0
Answers: 0
Star schema - splitting dimensions into multiple smaller dimensions
I have been working in dashboarding for a long time and have always been using the traditional kimball star schema to build my reporting and dashboarding on. The architecture team at work have been wo...
user3195568
Votes: 0
Answers: 3