what is BUS Schema?
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.