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
0 answers

Should I build a separate dimension for Visas?

I am designing a data mart for University students and confused about visa and passport information that should it go in the student dimension or should I define a separate dimension for it. Which would be the better approach?
LondonUK
  • 437
  • 1
  • 8
  • 20
0
votes
1 answer

Insert multiple records into fact table based on fields in single record

I'm working in Pentaho 4.4.1-GA (Kettle / PDI). The database is Postgres. I need to be able to insert multiple records into a fact table based on the fields that come from a single record. The single record contains fields: productcode1,…
Rakesh Thakoordyal
  • 1
0
votes
1 answer

How does one integrate a month-grain fact table into an order grained cube in SSAS?

We are a retailer and our primary sales cube is defined at the order line level. I have the need to integrate some much lower grained numbers (month) from the accounting system into our reporting environment. The new data is at the grain of month,…
Scott Wood
  • 1,077
  • 3
  • 18
  • 34
0
votes
1 answer

Designing Fact table associated with multiple attribute hierarchy members

I am designing a warehouse to accommodate a movie related database. I have a table with the columns - Title, Genre, SalesAmount, ProductionAmount. One such row would be say GodFather, Crime|Drama,1000000,20000. I want to move this to DW, I am…
VKarthik
  • 1,379
  • 2
  • 15
  • 30
0
votes
1 answer

New to Data Warehousing and Data Marts

I'm completely new to Data Warehousing and Marts and wanted to ask for some advice on the best resources to learn and gain knowledge to start me off on the right path. I have a project to work on but need some guidance or somewhere to start really.…
Andy_RC
  • 81
  • 1
  • 3
0
votes
0 answers

Handling more than 2 Fact Tables in Qlikview

I am new to Qlikview and I am trying to get a solution to Link more than 3 Fact Table, I've used the approach on "Handling Multiple fact tables in Qlikview", and works perfectly, however when I am trying to link a 3rd table I get an error of table…
Eric Elcock
  • 1
0
votes
1 answer

SSAS Performance: Multiple measures+no Dim vs one measure+DimType

I am building a finance cube and trying to understand the best practice while designing my main fact table. What do you think will be a better solution: Have one column in the fact (amount) and have an additional field which will indicate the type…
OrenHenig
  • 80
  • 3
  • 9
0
votes
1 answer

Read csv file from prolog and change to facts/clause

I use csv_read_file to read a csv file, which is: csv file: "nsubj(love-1, carol-2)" "nsubj(like-3, carol-2)" code: csv_read_file('test.csv',L) I got things like: L = [row('nsubj(love-1, carol-2)'), row('nsubj(like-3, carol-2)')] But what I need…
ba9el
  • 28
  • 4
0
votes
0 answers

OWL-API get Inferred Individuals

I have an existing Ontology loaded inside a Singleton Class 'Ontology'. I would like to have the corresponding inferred Ontology. This is my actual code : List> gens = new ArrayList
user3627555
  • 5
  • 1
0
votes
1 answer

Multiple dates in a fact record

I have a fact table that tracks multiple actions and dates for a specific population. I am having a hard time creating a query that returns the resultset I would expect for this table. Here is a sample of this table: Record applicant_count…
user3613294
  • 11
  • 1
0
votes
1 answer

Strategy to avoid joining fact tables

I have three facts in my warehouse that can be related events in my relational db. They are PhoneContact, Appointment and Donation. A PhoneContact can result in an Appoinment and/or a Donation. I already have the Apppointment and Donation facts…
Brian B
  • 1
  • 1
0
votes
1 answer

Using SSAS, how to design a contact info retrieval based on filters?

I am new to SSAS trying and need help designing this reporting requirements: Filter for Customers based on dimensions (regular and fact) in various tables related by many-to-many relationships With this list of Customers, retrieve their contact…
cte00
  • 33
  • 5
0
votes
1 answer

How to set the text of a UITextView from an array?

I am trying to create a simple fact or joke app. It's simply not working. How do I get the UITextView to load a string, which is stored in an NSArray. Here is my code so far. // Do any additional setup after loading the view, typically from a…
Flinders Flanders
  • 19
  • 2
0
votes
1 answer

Custom puppet facts not executing

I have a few custom facts on the puppet server in the standard location: [module_dir]/lib/puppet/facter/[fact_name].rb Here is an example: require 'facter' Facter.add("fact_name") do setcode do "fact_name_value" end end I see they are…
Andy Arismendi
  • 50,577
  • 16
  • 107
  • 124
0
votes
1 answer

Drools json Api call which contains Date (rule engine)

I am trying to call Drools Json api and one of my facts is of type Date. I am not sure how to construct the json string for that. !!!!????????? :( here is what I have: my drl file: package com.beachmint.common declare Order orderId: Integer …
Faraz Zahabian
  • 11
  • 2
1 2 3
…
12 13