What is BUS Schema?

Showing Answers 1 - 2 of 2 Answers

Thiagu

  • Feb 20th, 2006
 

BUS Schema is composed of a master suite of confirmed dimension and standardized definition if facts.

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.

  Was this answer useful?  Yes

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions