I have one table wihich is very big in size and column wise too (100 columns). I have 10 columns of which inside one column there are 100 nessted columns. I explode this 100 columns and then i try to count no of rows by groupby function which makes my table. i want to implement star schmea on this table to export to powerbi
I have tried making dimension table with distinct function and primary key with montomicallyid(). when i try to join the dimesnio ntable to fact table all the keys are wrongly joined. I cant figure out why the keys are joining wrongly. I am using azure spark synapse
