SCD type 4 - Fast growing dimension
In normal scenarios the dimension tables tend to grow slowly. That is the reason, they are called slowly changing dimensions. Example: Loc...
Showing posts with the label DataWareHouse
Slowly Changing Dimensions (SCD) - Types | Data Warehouse
Vijay Bhaskar
Slowly Changing Dimensions: Slowly changing dimensions are the dimensions in which the data changes slowly, rather than changing regularly ...
Data Mining
Vijay Bhaskar
Data mining is the process of finding patterns from large data sets and analyzing data from different perspectives. It allows business us...
Data Mart
Vijay Bhaskar
A data mart is a subset of the data warehouse, which concentrates on a specific business unit. A data mart, may or may not derived from a...
Data Profiling
Vijay Bhaskar
Data profiling is the process of examining the quality of data available in the data source (database or file) and collecting statistics ...
Data Warehouse Design Approaches
Vijay Bhaskar
Data warehouse design is one of the key technique in building the data warehouse. Choosing a right data warehouse design can save the pro...
Extraction Methods in Data Warehouse
Vijay Bhaskar
The extraction methods in data warehouse depend on the source system, performance and business requirements. There are two types of extra...
Logical and Physical Design of Data Warehouse
Vijay Bhaskar
Logical design: Logical design deals with the logical relationships between objects. Entity-relationship (ER) modeling technique can be u...
Data Warehouse
Vijay Bhaskar
A data warehouse is a relational database that is designed for query and business analysis rather than for transaction processing. It con...
Data Warehouse Dimensional Modelling (Types of Schemas)
Vijay Bhaskar
There are four types of schemas are available in data warehouse. Out of which the star schema is mostly used in the data warehouse design...
Types of Facts in Data Warehouse
Vijay Bhaskar
A fact table is the one which consists of the measurements, metrics or facts of business process. These measurable facts are used to know...
Types of Dimensions in data warehouse
Vijay Bhaskar
A dimension table consists of the attributes about the facts. Dimensions store the textual descriptions of the business. With out the dim...