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!
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!