|
What is a Cube and Linked Cube with reference to data warehouse?A data cube stores data in a summarized version which helps in a faster analysis of data. Where as linked cubes use the data cube and are stored on another analysis server. Linking different data cubes reduces the possibility of sparse data.
e.g. A data cube may store the Employee_performance. However in order to know the hours which calculated this performance, one can create another cube by linking it to the root cube (in this case employee_performance).What is a Cube and Linked Cube with reference to data warehouse?Logical data representation of multidimensional data is depicted as a Cube. Dimension members are represented by the edge of cube and data values are represented by the body of cube.
Linked cubes are the cubes that are linked in order to make the data remain constant.
|
