If there are ten thousand records in a source system, how do we ensure that all ten thousand are loaded to the target without any dysfunctional values? The issue here… read more →
A Surrogate Key is a sequence generated key which is assigned to be a primary key in the system (table).
De-normalization means a table with multi duplicate key. The dimension table follows De-normalization method with the technique of surrogate key.
It is a collection of integrated databases designed to support operational monitoring. Unlike the OLTP databases, the data in the ODS are integrated, subject oriented and enterprise wide data.
These are combinations of one or more real cubes and require no disk space to store them. They store only definition and not the data.
Cubes are data processing units composed of fact tables and dimensions from the data warehouse. They provided multidimensional analysis.
Measures are numeric data based on columns in a fact table.