We are working on a upgrade project. Earlier we had only detailed data for a table which has all the measurements. now we are adding 3 fact tables to it which have yearly compliance calculations and other calculations which are done yearly. what would be the best way to create the data model. should I concatenate them all or keep them separate and add the alias table for dimensions as per requirement?
