Forum Discussion
Solved
Normalizing one flat table into star schema - giving wrong numbers
I'm trying to create a star schema from one big flat table. I'm doing this with power query along with sql native queries (i don't have permissions to create views). I'm extracting multiple dim table...
I ended up figuring out the issue on my own. And it was that I needed to sort tables before adding index(SK) columns and join dim tables to the fact table.
I didn't encounter this before, but this time, the data was huge and I suppose the distribution of SKs in fact table from dim tables got messed up. A lesson learned!
YukiK The logic seems sound. What kind of measures are you using and are your relationships in the right direction?
Not really using measure at this point. The relationships directions look correct and they base in SK columns I added. What's weird is that when I join, let's say, on category column (define each row uniqeuly) rather than SK columns, it works.
Somebody mentioned "auto-exist" migth be doing something...