Roleplay Dimension Table: This type of table has multiple and varied relationships with fact table.Degenerate Dimension Table: In degenerate dimension, the dimension attribute is not a separate table and is sorted as a part of the fact table.Junk Dimension Table: In order to avoid various foreign keys, in fact table, this table is created with different and unrelated attributes.The company shares the same dimension table for other purposes without making changes. Conformed Dimension Table: This type of dimension table is shared across various different data businesses by the same company.Slowly Changing Dimention Table: The dimension attributes here change slowly with time rather than changing at regular interval of time.The size of the dimension table is small with thousands of rows, but the size can, however, grow later on. This table type grows horizontally and has hierarchical relationships. This table type is known as de-normalized tables. The various columns of the dimension-type table are basically attributes of dimension table. There is no limit set for a given number of dimensions. Dimension-type table is interconnected to fact-type table by the use of keys. It is a combination of dimensions and the value of attributes. They are known as degenerated dimensions.Ī dimension-type table consists of the dimensions along which the measurement is taken, in fact-type table. Degenerated dimension: These measure types of dimensions of the fact table are the ones which are non-additive measures or which cannot be added.Semi-additive measures store basic unit of measurement of business process. Semi-additive measures are the ones which are added to some dimensions and not all dimensions. Fully additive measures are the ones added to all dimensions. Additive measures: Attribute format of fact table can be fully additive or semi-additive.As such, there is no need to store such data as it does not convey any information. This data has no unit of measurement because it does not indicate any quantity. Sparse data: There is some data in a fact-type table which has a null measure or it measures to zero.The more the data grain the better the fact-type table. Data grain must be performed at the highest level. Data grain indicates the depth of information stored in the fact table. Data grain: Fact table consists of data in textual format as well as numbers.This key is unique and identifies a row in the fact table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |