Our company would like to implement a data warehouse consolidating all application databases (we have 4 databases => 3 for application db, 1 for common data repositories). Is star schema applies to this kind of consolidation/merging of sources (multiple fact tables will be constructed and dimension tables will be shared across facts of different measurements) or what is the better schema for this scenario?
