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...
Category: Data Warehouse
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 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.
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..
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...