Part 5: Data Warehouse Dimensional Modelling

In this series, the previous post was about Part 4: Types of Data Warehouses. Please go through if you missed it. What is Dimensional Modelling? The techniques, concepts and methodologies used in designing Data Warehouse is called Dimensional Modelling. The Data Models are designed in discussion with Subject Matter Experts and Data Governance Representatives of the Business. The Data Modeler is responsible for building the Data Model after...

Read More

Rooting Huawei Honor 6 H60-L04 (Indian Version).

Hi Everyone, Today I am going to give steps on How to root Huawei Honor H60-L04 (Indian Version)?. This will enable the Root Access and will not upgrade your Android Version. I have successfully rooted my Huawei Honor 6 with the below steps. All the credits for the process goes to the thread posted in Huawei Honor Club Forum. Warning: Before we start with the process, I would like to inform you that I or this site will not responsible for any...

Read More

Part 4: Types of Data Warehouses

In this series, the previous post was about Part 3: Types of Data Warehouse Architectures. Please go through it, if you missed it. A data warehouse is a relational/multidimensional database that is designed for query and analysis rather than transaction processing. A data warehouse usually contains historical data that is derived from transaction data. It separates analysis workload from transaction workload and enables a business to consolidate...

Read More

Part 3: Types of Data Warehouse Architectures

Data Warehouse Architectures In this series, the previous post was about Part 2: Data Warehousing Concepts - OLTP Vs Data Warehouse. Please go through it if you did not read. Below are some of the widely used Data Warehouse architectures. Basic Data Warehouse Architecture Data Warehouse Architecture with Staging Area Data Warehouse Architecture with Staging Area and Data Marts Basic Data Warehouse Architecture In the Basic Data...

Read More

Part 2: Data Warehousing Concepts - OLTP Vs Data Warehouse

OLTP Vs Data Warehouse In this series, the previous post was about Part 1: Data Warehousing Concepts. Please go through it if you did not read. OLTP and Data Warehouse have many differences in the architecture, process and performance. Here are the differences on various aspects. Performance Data Modification Design Operation Historical Data Performance Data Warehouse are developed to accommodate adhoc queries. So data warehouse...

Read More

Part 1: Data Warehousing Concepts

What is a Data Warehouse ? A data warehouse is a relational database that is designed for faster querying and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. In addition to a relational database, a data...

Read More