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

HRA Excemption Calculator

Hi Everyone, Here is a simple tool developed to find out the House Rent Allowance (HRA) Exception for the financial year. This is applicable in India. HOUSE RENT ALLOWANCE – SEC 10 (13A) READ WITH RULE 2A : When the employee is occupying a rented residential accommodation, the amount of house rent allowance received by him is exempt to the extent of least of the following amounts: a) 50% of the salary where residential house is situated at Mumbai, Calcutta, Chennai or Delhi and 40% of the salary where residential house is situated at any other...

Read More

Quick Rename: Quick File Name Changer for you !

Hi Everyone, I have a simple and quick batch file name changer for your convenience and it is named as "Quick Renamer". It is minimally tested to ensure the quality and it is suitable for renaming your photos (It helps me a lot in labeling the photos), audio and video files. Since it is a Beta Software, it may contain lot of hidden bugs. So for safety please backup your files before performing any tasks. Statutory Warning: Please take a backup...

Read More

How to Download, Install and Configure Informatica Power Center 9.x ?

Hi All, I am trying to explain you how to Download, Install and Configure Informatica Power Center 9.x. Please follow the steps one by one, to complete the entire process. Note: This tutorial and the software is just for learning purpose. Any commercial use may require the respective license from the vendor. Pre-requisites for the installation Informatica Power Center Server Installer Informatica Power Center Client Installer Any Database...

Read More