Fact Table - Types of Fact Tables

Types of Fact Tables

There are basically three fundamental measurement events, which characterizes all fact tables.

  • Transactional
A transactional table is the most basic and fundamental. The grain associated with a transactional fact table is usually specified as "one row per line in a transaction", e.g., every line on a receipt. Typically a transactional fact table holds data of the most detailed level, causing it to have a great number of dimensions associated with it.
  • Periodic snapshots
The periodic snapshot, as the name implies, takes a "picture of the moment", where the moment could be any defined period of time, e.g. a performance summary of a salesman over the previous month. A periodic snapshot table is dependent on the transactional table, as it needs the detailed data held in the transactional fact table in order to deliver the chosen performance output.
  • Accumulating snapshots
This type of fact table is used to show the activity of a process that has a well-defined beginning and end, e.g., the processing of an order. An order moves through specific steps until it is fully processed. As steps towards fulfilling the order are completed, the associated row in the fact table is updated. An accumulating snapshot table often has multiple date columns, each representing a milestone in the process. Therefore, it's important to have an entry in the associated date dimension that represents an unknown date, as many of the milestone dates are unknown at the time of the creation of the row.

Read more about this topic:  Fact Table

Famous quotes containing the words types of, types, fact and/or tables:

    “The wider the range of possibilities we offer children, the more intense will be their motivations and the richer their experiences. We must widen the range of topics and goals, the types of situations we offer and their degree of structure, the kinds and combinations of resources and materials, and the possible interactions with things, peers, and adults.”
    —Loris Malaguzzi (1920–1994)

    “If there is nothing new on the earth, still the traveler always has a resource in the skies. They are constantly turning a new page to view. The wind sets the types on this blue ground, and the inquiring may always read a new truth there.”
    —Henry David Thoreau (1817–1862)

    “What makes the United States government, on the whole, more tolerable—I mean for us lucky white men—is the fact that there is so much less of government with us.... But in Canada you are reminded of the government every day. It parades itself before you. It is not content to be the servant, but will be the master; and every day it goes out to the Plains of Abraham or to the Champs de Mars and exhibits itself and toots.”
    —Henry David Thoreau (1817–1862)

    “O these encounterers, so glib of tongue,
    That give a coasting welcome ere it comes,
    And wide unclasp the tables of their thoughts
    To every ticklish reader! Set them down
    For sluttish spoils of opportunity
    And daughters of the game.”
    —William Shakespeare (1564–1616)