Explain what you mean by Bus Schema.

1.	Explain what you mean by Bus Schema.
Answer» An important part of ETL is dimension identification, and this is largely DONE by the Bus Schema. A BUS schema is actually COMPRISED of a suite of VERIFIED dimensions and uniform definitions and can be used for handling dimension identification across all businesses. To put it another way, the bus schema identifies the common dimensions and facts across all the data marts of an organization just like IDENTIFYING conforming dimensions (dimensions with the same information/meaning when being referred to different fact tables). Using the Bus schema, information is given in a standard format with PRECISE dimensions in ETL.

Discussion