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:
“... there are two types of happiness and I have chosen that of the murderers. For I am happy. There was a time when I thought I had reached the limit of distress. Beyond that limit, there is a sterile and magnificent happiness.”
—Albert Camus (1913–1960)
“Our children evaluate themselves based on the opinions we have of them. When we use harsh words, biting comments, and a sarcastic tone of voice, we plant the seeds of self-doubt in their developing minds.... Children who receive a steady diet of these types of messages end up feeling powerless, inadequate, and unimportant. They start to believe that they are bad, and that they can never do enough.”
—Stephanie Martson (20th century)
“Everybody has that thing where they need to look one way but they come out looking another way and that’s what people observe. You see someone on the street and essentially what you notice about them is the flaw. It’s just extraordinary that we should have been given these peculiarities.... Something is ironic in the world and it has to do with the fact that what you intend never comes out like you intend it.”
—Diane Arbus (1923–1971)
“Hast thou named all the birds without a gun?
Loved the wood rose, and left it on its stalk?
At rich men’s tables eaten bread and pulse?
Unarmed, faced danger with a heart of trust?”
—Ralph Waldo Emerson (1803–1882)