Types of Fact

Till now, we have already discussed about types of dimension. So lets move to another concept in dimensional modelling, i.e, FACT . A fact is a  measure or metrics of business process. In simple words, a fact is a focus of interest for the decision making process. Facts are summarized historical and…

Continue reading

Types of Dimension

Dimensional modelling has two basic concepts – fact and dimension. Dimensions store the textual descriptions of the business attribute. Without the dimensions, we cannot measure the facts and facts are just disordered Numbers. Here we will discuss about different types of dimension in data warehouse.

Continue reading

Dimensional Modeling

I have discussed about the Data Modeling  in my previous article – What is Data  Modeling ? . I know most of you will be interested in knowing the modeling technique for data warehouse. Dimensional modeling is used for most of the data warehouse systems.

Continue reading

What is Data Modeling ?

Most of us are aware about Database and Database Management System. But do you know how the data is organized in a database. What is the relation between data in database ? For designing a database structure , which is easy to use and maintains the data security, we need…

Continue reading