Changed the partition by just to use the fk on the dimension tables.