Fact & Dimension

qlikview979 — Thu, 23 Apr 2015 08:56:30 GMT

Hi experts,

What is the difference between Fact & dimension table with diagram ?

Re: Fact & Dimension

Thu, 23 Apr 2015 09:08:32 GMT

Dimension Table features

1. It provides the context /descriptive information for a fact table measurements.
2. Provides entry points to data.
3. Structure of Dimension - Surrogate key , one or more other fields that compose the natural key (nk) and set of Attributes.

4. Size of Dimension Table is smaller than Fact Table.

5. In a schema more number of dimensions are presented than Fact Table.

6. Surrogate Key is used to prevent the primary key (pk) violation(store historical data).

7. Values of fields are in numeric and text representation.

Fact Table features

1. It provides measurement of an enterprise.

2. Measurement is the amount determined by observation.

3. Structure of Fact Table - foreign key (fk), Degenerated Dimension and Measurements.

4. Size of Fact Table is larger than Dimension Table.

5. In a schema less number of Fact Tables observed compared to Dimension Tables.

6. Compose of Degenerate Dimension fields act as Primary Key.

7. Values of the fields always in numeric or integer form.

Re: Fact & Dimension

awhitfield — Thu, 23 Apr 2015 09:18:06 GMT

Why not just google it? There are great descriptions on Wikipedia.

Andy

Re: Fact & Dimension

Thu, 23 Apr 2015 09:24:19 GMT

Hi Mahesh,

maybe have a look at this, should help you

Dimensions and Measures

hope that helps

thanks

Joe

topic Re: Fact & Dimension in QlikView

Fact & Dimension

Re: Fact & Dimension

Re: Fact & Dimension

Re: Fact & Dimension