A BUS Schema or a BUS Matrix? A BUS Matrix (in Kimball approach) is to idetify common Dimensions across Business Processies; ie: a way of identifying Conforming Dimensions.
Bus Schema : Let we consider/explain these in x y axis
Dimension Table : A B C D E F Fact Table: R S Relation between Fact and Dim tables as follows:
R->> A B E F and S->>D C A
A confirmed must be identified across different Subject.(Any dimension which is found in two fact say R S : we need to takes these as Vertical axis say x axis and we need to take Dimensional table as Horizontal axis as Y axis.this type of construction of matrix is called bus matrix. these are intially constructed before the universe is created.we can say this intial layout in designing a schema.Every Schema which is Started as a Star Schema and then it expands to Multi Star Snow Flake Constellation Schema. Thanks & Regards Sivakumar.R
