[go: up one dir, main page]
Scribd
Upload
103 views1 page

Types of Facts Table - Javatpoint

There are three main types of fact tables: 1) Transaction fact tables contain data about individual events or transactions like sales. Each transaction is stored as a separate row. 2) Snapshot fact tables provide a snapshot of metrics and measurements like performance or inventory levels at a point in time like the end of each month. 3) Accumulated fact tables track values that accumulate over time as a process progresses, like the status of an order as it moves through processing steps until completion.

Uploaded by

Anil Kumar Mylu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
103 views1 page

Types of Facts Table - Javatpoint

There are three main types of fact tables: 1) Transaction fact tables contain data about individual events or transactions like sales. Each transaction is stored as a separate row. 2) Snapshot fact tables provide a snapshot of metrics and measurements like performance or inventory levels at a point in time like the end of each month. 3) Accumulated fact tables track values that accumulate over time as a process progresses, like the status of an order as it moves through processing steps until completion.

Uploaded by

Anil Kumar Mylu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Types of Facts Table Types of Fact Table

There are three types of fact tables:


The fact table is a central table in the data schemas. It is found in the centre of a star schema or
snowflake schema and surrounded by a dimension table. It contains the facts of a particular
1. Transaction Fact Table
business process, such as sales revenue by month. Facts are known as measurements or
matrices. It captures a measurement or a metric. It is an essential concept for data warehousing The transaction fact table is a basic approach to operate the businesses. These fact tables
and BI Certification. represent an event that occurs at the primary point. A line exists in the fact table for the
customer or product when the transaction occurs.
The fact table stores quantitative information of analysis that is not arranged. The fact table is
a primary table in the dimensional model. It also contains measurement, metric and Many rows in a fact table connect to a customer or product because they are involved in
quantitative information. multiple transactions. Transaction data is often structured quickly in a one-dimensional
framework. The lowest-level data is the rawest dimensional data that cannot be done by
summarized data.

2. Snapshot Fact Table

The snapshot fact table describes the state of things at a particular time and contains many
semi-additive and non-additive facts.

Example: The daily equilibrium fact is expressed by the customer dimension but not by the
time dimension.

Periodic snapshots require the performance of the business at regular and estimated time
intervals. Unlike a transaction fact table where we load a row for each event, with periodic
snapshots, we take a picture of the activity at the end of the day, week, or month, and then
another picture at the end of the next period.

Example: Performance summary of a salesman during the previous month.


Types of Facts
There are three types of facts:
3. Accumulated Fact Sheet

1. Summative facts: Summative facts are used with aggregation functions such as sum (), The accumulated fact table is used to show the activity of a process that has a beginning and

average (), etc. an end.

2. Semi summative facts: There are small numbers of quasi-summative fact aggregation For example, we are processing an order. An order remains in the process until it will be
functions that will apply.
processed. As the step towards completing the order is completed, the corresponding row in
For example, consider bank account details. We also cannot also apply () for a bank the fact table is updated.
balance which will not have useful results, but the minimum() and maximum()
functions return useful information. Fact less Facts
3. Non-additive facts: We cannot use numerical aggregation functions such as sum (),
average (), on non-additive facts. For non-additive facts, ratio or percentage is used.

You might also like