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 create puppet external structured facts from script, such as python or bash?

I have seen the documentation, especially External Facts and Custom Facts. I have the following yum_repos.rb: require 'facter' Facter.add('yum_repos') do setcode '/usr/bin/python3 /opt/puppetlabs/puppet/cache/lib/facter/yum_repos.py' end I have…
Edward Ned Harvey
  • 6,525
  • 5
  • 36
  • 45
0
votes
1 answer

How do I populate a fact table from more than one table

I am doing a school assignment but I do not know how to populate a fact table. My query to do it is Select CustomerID from dim_cust Select ProductID from dim_product select InvoiceID from dim_invoice insert into [dim_fact] ([CustomerID],…
ilikebananaboaticecream
  • 1
  • 1
0
votes
0 answers

Best Practice to load single fact table from multiple sources in Redshift

Is there a best practice to load the fact data from multiple sources in redshift? Redshift doesn't have a partitioning concept, it does however have the distribution concept. With distribution, one would need to use the DELETE operation which is…
Shaounak Nasikkar
  • 194
  • 1
  • 11
0
votes
1 answer

How to filter a measure by two dimension members

I have a very simple question that I can't resolve alone. Here it is: say you have a PERSON fact, with a field Birthdate which is linked to a dimension DATE correctly filled, and with the measure "People Number". In MDX, how can I get the people…
lolveley
  • 1,659
  • 2
  • 18
  • 34
0
votes
2 answers

Periodic snapshot fact table - Design question

I'm working on the design of a new periodic snapshot fact table. I'm looking into health insurance claims and the amount of money people owe to the insurance company and the amount they've already paid. Data in the table will look like…
xcelm
  • 541
  • 1
  • 6
  • 19
0
votes
1 answer

Drools Expert 5.x: API call to get list of all current facts?

How do I list all the current inserted facts so that I can serialize them ? Kinda like running '(facts)' in a CLIPS session ?
monojohnny
  • 5,894
  • 16
  • 59
  • 83
0
votes
1 answer

Best approach to build factless fact in star schema DWH

I have a case where I'm building factless fact table for my DWH. There are 2 dimension that I want to ask for this case: location and store. I have 2 approach. Building dim_store and fact_account. Then put all the location data into the…
Mohammad Iqbal
  • 317
  • 4
  • 13
0
votes
1 answer

Using Factless Fact table used as source for Fact Table

I have a design for a Property / Occupancy factless fact so I can capture the data for when customers move in and out of properties. However I am not sure if it is best practice to use this as a source for maybe a occupied flag for my SCD…
cherylberyl
  • 13
  • 2
0
votes
0 answers

A Schema with multiple fact tables connecting to one dimension table

I'm trying to create a Star Schema/Galaxy Schema in my datawarehouse and am trying to avoid creating a Snowflake Schema. I currently have 6 dim tables and 10 fact tables. Is it alright to have multiple fact tables connecting to one dimension table?…
Zafear
  • 13
  • 4
0
votes
2 answers

Best practice to Load Fact table in MS SSIS

I am new to SSIS in data warehouse. I am using Microsoft business intelligence studio. I have 5 Dimensions each having some PK. I have a Fact table that contains all the PK of Dimensions, means their is a foreign key relationship exist ( as in star…
Saboor Awan
  • 1,567
  • 4
  • 24
  • 37
0
votes
1 answer

Fact Tables - CRM - Customer X Events

I am new in DW and I have a simple question. Imagine that I want to create a DW to analytical CRM. I have a fact table called Event and I have a dimension called Customer. The problem is. One event can have N Customers, and one Customer can be in N…
p.magalhaes
  • 7,595
  • 10
  • 53
  • 108
0
votes
1 answer

Hubspot(CRM) datawarehouse

I am planning to create a datawarehouse for Hubspot CRM sourced data. I'm pulling Contracts,Contacts,Deals,Students tables data from Hubspot CRM tool.Is anybody having any idea on this. How to create facts and dimension table schema input on tables?
remy
  • 1
  • 2
0
votes
2 answers

Merging Fact-Tables in Amazon Redshift

I try to build a galaxy-schema in Amazon Redshift. I started with all the dimensions and with a few workarounds I got them working with SCD2 - Kimball style. Now I'm trying to get some fact tables working. The facts in our company are very…
Hawtin
  • 101
  • 10
0
votes
1 answer

ansible - loop through fact and process each set of values

I have set a fact set_fact: props: "{{ parse_result.stdout | from_json }}" The fact looks something like this: { "changed": false, "ansible_facts": { "props": [ { "build_number": "1.0.0.2", …
TNV
  • 973
  • 2
  • 11
  • 26
0
votes
1 answer

Unit Price and Discounts - Fact or Dimension Table

I'm working on a datamart for our sales and marketing departments, and I've come across a modeling challenge. Our ERP stores pricing data in a few different ways: List pricing for each item A discount percentage from list pricing for a product…
cisenb
  • 23
  • 1
  • 7
1 2 3
…
12 13