Category: Data Warehouse

Data Marts

Data Marts

What is a Data Mart ?? A Data Mart is a subset or form of Data Warehouse only but its scope is limited to a particular subject.In other words, It is a specific repository...

Metadata And Data Warehousing

Metadata And Data Warehousing

1. Metadata What is Metadata??? Metadata may be defined as’ Data about data’ or ‘Data ( mostly definitions) about the structures containing other data’ . for e.g. a table has four columns , two...

Data warehouse Architecture

Data warehouse Architecture and Process Flow.

Depending upon the business requirements and the budget , different data Warehouse may have different architectures Types Data Warehouse Architecture – Type 1 : Source (OLTP) —–> Staging Area ——> Data Warehouse ——> Reporting...

Surrogate key in Data Warehouse

Surrogate key In Data warehouse.

Defining Surrogate Key : Surrogate Key may be defined as a system generated key which is used to maintain unique records in the Data warehouse databases. Need for Surrogate key : We all know...

Introduction.. 0

Introduction..

No Business can run without DATA.  Infact ,the success of any business organization depends upon how effectively it analyzes and acts on data. But , How Data is important for Business ? The Success...