E-R Modeling and Dimensional Modeling:
E-R Modeling :In this E-R Modeling technique for the purpose of the retriving data, we need to apply "More" number of joins .
DWH projects we need to deal with Current data and History data for that reason all tables are having huge amount of data.On huge amount of data tables if we are apply more number of Joins Query Performance completely "degrade".
Dimensional Modeling:In this Dimensional Modeling technique for the purpose of the retriving data, we need to apply "Less" number of joins .
DWH projects we need to deal with Current data and History data for that reason all tables are having huge amount of data.On huge amount of data tables if we are apply Less number of Joins Query Performance "Increased".
E-R Modeling :In this E-R Modeling technique for the purpose of the retriving data, we need to apply "More" number of joins .
DWH projects we need to deal with Current data and History data for that reason all tables are having huge amount of data.On huge amount of data tables if we are apply more number of Joins Query Performance completely "degrade".
Dimensional Modeling:In this Dimensional Modeling technique for the purpose of the retriving data, we need to apply "Less" number of joins .
DWH projects we need to deal with Current data and History data for that reason all tables are having huge amount of data.On huge amount of data tables if we are apply Less number of Joins Query Performance "Increased".
