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
0
votes
1 answer

How to insert data in DataWarehouse tables for early arriving facts ?What is the procedure to be followed?

I want to know how to insert data in data warehouse tables for early arriving facts ? What is the the procedure to be followed ?
KrishnaSaran draksharapu
  • 71
  • 8
0
votes
1 answer

Update in data warehouse fact table

Reading upon many Kimball design tips regarding fact tables (transaction, accumulating, periodic) etc. I'm still vague what should I do with my case of updating a fact table which I believe is not that uncommon. To the case. We're processing…
Kamil Gosciminski
  • 16,547
  • 8
  • 49
  • 72
0
votes
1 answer

How to create a data history in a dimension without using slowly changing dimension?

I'm working on my fact table and I want to create history table for each dimension without using slowly changing dimension because my data flows are bulky and it will take too much time to finish the process of feeding the fact table ? Generally,…
Amira Bedhiafi
  • 8,088
  • 6
  • 24
  • 60
0
votes
2 answers

BI - fact table design with incompatible grains

I'm quite new to BI designing DB, and here some point I do not understand well. I'm trying to import french census data, where I got population for each city. For each city, I have population with different age classification, that can't really…
Groflo
  • 17
  • 8
0
votes
2 answers

puppet facts on centos fails but works in ubuntu

I got following error while running below puppet module. I have 2 agents one is ubuntu 18.04 and centos7 Below code works in ubuntu and stopping the firewall, but in centos i got below error. Error: Could not retrieve catalog from remote server:…
madprinciple
  • 13
  • 6
0
votes
1 answer

Creating nested Puppet fact (Ruby) by iterating over gem query output

I have working Ruby code to query DNS details and create Puppet custom facts (puppet 5, Facter 3.11.6) however I am trying to modify it to create nested facts from the key/value pairs that the query obtains. Code that works to set individual facts…
xit
  • 135
  • 1
  • 12
0
votes
1 answer

Physical Pkey in Fact table

I was in an interview. I did some code for them and they were keen on why there is no PKEY in Fact table, why there is duplicate data. In my opinion, FACT holds foreign keys from dim and there is no need of Physical PKEY. And on obvious point…
lokesh
  • 85
  • 1
  • 9
0
votes
1 answer

JBoss Drools Working Memory multiple facts

This is my rule: rule "Your First Rule" when $testRule : TestRule(count >= 100) then System.out.println("100 PACKETS!"); end This is how I create the RuleBase and WorkingMemory: public void invokeRules(){ RuleBase…
cwrwatson
  • 61
  • 1
  • 6
0
votes
3 answers

Fact and Dimension Tables in DW

I wonder why fact tables are bigger in size than dimension tables in data warehouses. Dimension tables contain the attribute-level information, and are highly de-normalized, so why are dimension tables not bigger in size ?
Arzu
  • 46
  • 3
  • 6
0
votes
1 answer

Design of fact table

My question is about modeling of fact_table in data warehouse. for example , we have users that subscribe to different subjects and we want to track when they started subscription. each user belongs to specific department. and users can change their…
sia
  • 537
  • 1
  • 6
  • 22
0
votes
2 answers

Consolidating fact records by timestamp

I am in a Microsoft SQL Server database. I would like to consolidate start and end periods for employees. For example, given the following simple table: create table dbo.foo ( employee_key bigint, effective_start_date date, effective_end_date…
Pablo Boswell
  • 805
  • 3
  • 13
  • 30
0
votes
1 answer

PostgreSQL - How do you create a "dimension" table from a 'select distinct' query and create a primary and foreign key?

I have a fact table with many entries, and they have 'ship to' columns that are very closely related, but none of the columns are always unique. I would like to make a dimension table for this, and reference the new dimension table rows using a…
Emerson Peters
  • 373
  • 2
  • 9
0
votes
0 answers

Fact constellation schema with 2 fact table

I need your help about constellation schema, I want to analyze a crime dataset, but I should have at least two facts table… Can anyone give me some ideas how can I do it? PS: I already found a dataset Thank you so much.
Kate
  • 145
  • 3
  • 12
0
votes
1 answer

SSIS - Cannot insert duplicate key in object 'dbo.FACT_TABLE'

I know that we can't have duplicate records in Fact Table but I'm very new in SQL Integration Services and I'm looking for a package that can recognize that if the surrogate keys already exists in fact tables... In this moment I've this package: …
John_Rodgers
  • 181
  • 1
  • 11
0
votes
1 answer

How to access a specific element of fact in a list in prolog

The structure of the facts is %structure student(ID,FirstName,LastName,[courseList]). course(CourseCode,CourseTtile,Credits,Level). Following is the fact. student(20135639,'Mohammed','Abdul Wahab', [course('ITIS411','DATABASE SYSTEM…
Far
  • 341
  • 2
  • 11
  • 25
1 2 3
…
12 13