Stack Overflow
Stack Overflow

Questions tagged [fact]

A fact or fact table is the central table in a Star or Snowflake schema of a data warehouse. A fact table stores quantitative information for analysis and is often denormalized. It measures the business operations in the organization. It is included in every data warehouse or data mart.

A fact or fact table is the central table in a Star or Snowflake schema of a data warehouse. A fact table stores quantitative information for analysis and is often denormalized. It measures the business operations in the organization. It is included in every data warehouse or data mart.

Facts are the measurements that result from a business process event and are almost always numeric. A single fact table rows has a one-to-one relationship to a measurement event as described by the fact table's grain. Fact table corresponds to a physical observable event.

Within a fact table, only fact consistent with the decraled grain are allowed. The fact table work with dimension tables. The fact table holds the ways in which the fact table data can be analyzed. There are two type of columns in there - foreign key columns for join with the dimensions and the measures columns, containing the data analyzed.

Example

In retail sales transaction, the quantity of a product sold and its extended price are good facts. Store manager's salary is disallowed in the fact table.

Links

182 questions
61
votes
5 answers

Ansible date variable

I'm trying to learn how to use Ansible facts as variables, and I don't get it. When I run... $ ansible localhost -m setup ...it lists all of the facts of my system. I selected one at random to try and use it, ansible_facts.ansible_date_time.date,…
turiyag
  • 2,757
  • 2
  • 22
  • 21
15
votes
1 answer

Is there a concept of slowly changing FACT in data warehouse

In data warehousing, we have the concept of slowly changing dimensions. I am just wondering why there is no jargon for 'slowly/rapidly changing FACTs' because the same Type1, Type 2 measures can be used to track changes in the FACT table.
Victor
  • 16,609
  • 71
  • 229
  • 409
12
votes
1 answer

Generating star schema in hive

I am from SQL Datawarehouse world where from a flat feed I generate dimension and fact tables. In general data warehouse projects we divide feed into fact and dimension. Ex: I am completely new to Hadoop and I came to know that I can build data…
Zerotoinfinity
  • 6,290
  • 32
  • 130
  • 206
5
votes
1 answer

How to model process and status history in a data warehouse?

Let's say that we have D_PROCESS, D_WORKER and D_STATUS as dimensions, and the fact F_EVENT that links a process (what) with a worker (who's in charge) and the "current" status. The process status changes over time. Shoud we store in F_EVENT one…
Francois
  • 10,730
  • 7
  • 47
  • 80
4
votes
1 answer

Ralph Kimball's Data warehouse toolkit book - Order lifecycle mart design

I'm reading Ralph Kimball's book on Data warehouse and Dimension Modeling. I am reading one of the case studies, and it is about dimension modeling for an order system, where the requirement is to capture an order lifecycle, from order to…
M.R.
  • 4,737
  • 3
  • 37
  • 81
4
votes
1 answer

creation of dimension and fact table through source tables

I have imported my flatfiles to SQL Server 2012 and created few tables (source tables). I need to build a cube in SSAS. But I need to make "dimension" and "fact" tables it seems with proper PK/FK relations. Could someone tell me whether I need to…
user2861497
  • 41
  • 1
  • 3
3
votes
1 answer

Turbo Prolog's 'save' analogue in SWI-Prolog

Is there any SWI's analogue for Turbo's save function, which saves into a file facts, previously loaded via consult and then appended via assert?
Mike Schekotov
  • 33
  • 6
3
votes
0 answers

Is it recommended to process a fact table as SCD type 2?

Background We are a courier company specialized in same-day-delivery for webshops. Customers can choose for same-day-delivery when ordering at a webshop, the webshop registers those packages in our system and at a certain cut-off time, we pick up…
Arwish
  • 31
  • 2
3
votes
1 answer

Transaction lifecycle tracking in data warehouse

How do you store facts within which data is related? And how do you configure the measure? For example, I have a data warehouse that tracks the lifecycle of an order, which changes states - ordered, to shipped, to refunded. And for a state like…
M.R.
  • 4,737
  • 3
  • 37
  • 81
3
votes
2 answers

is there concept like fact and dimension in bigquery

As we are planning to migrate the data from Teradata to google cloud(Bigquery). In Teradata we have key concepts like primary and foreign with help of this keys we are able to define relation between dimension and fact. Say for example I have 3…
sethu
  • 241
  • 1
  • 5
  • 13
3
votes
3 answers

Using OR operator with different / non existent facts in Prolog

I have a fact: loves(romeo, juliet). then i have an 'or' rule: dances(juliet) :- loves(romeo, juliet). dances(juliet) :- dancer(juliet). As you can see dancer fact does not exist but this should be no problem and dances(juliet) should return me…
Laimonas Sutkus
  • 3,247
  • 2
  • 26
  • 47
3
votes
1 answer

How to add multiple fact tables in a single mondrian cube in pentaho?

Need to associate multiple fact tables with a mondrian cube. The schema workbench doesn't allow to do so. How can we achieve this?
Akira
  • 47
  • 6
3
votes
4 answers

C / Find 190! (factorial) in c programming

I try to find 190! in C. I define my variable to long double, but I see that it calculate (correctly) only to 172!: After that, I got #INF00000...` There is any way to do it?
Or Smith
  • 3,556
  • 13
  • 42
  • 69
3
votes
2 answers

Are textual fields ever allowed in fact tables?

Are there any cases where I can have a textual field such as a description in a fact table? I currently have a fact table of meeting events (grain: row per meeting) with a number of dimensions such as date, client, location etc. I need to put the…
NabilS
  • 1,421
  • 1
  • 19
  • 31
2
votes
2 answers

Rapidly Changing Dimension

Recently, I came across the concept of Rapidly Changing Dimensions (Mini dimensions). I understand the part where the fast-changing attributes are removed from the main dimension table and put into a junk dimension (with all possible combinations…
marie20
  • 723
  • 11
  • 30
1
2 3
…
12 13