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

Prolog - Need information on facts

Say I had a fact such as: bigger(cat,mouse). If I wanted to describe this to someone, would I be correct in saying "cat is the first term within this fact and mouse is the second term" or would I refer to the cat and mouse as atoms and say "the cat…
JimmyK
  • 4,801
  • 8
  • 35
  • 47
0
votes
1 answer

Check list and database [Prolog]

I need to develop a predicate in Prolog able to compare a list against fact. In other words, if the names of the products residing in the list are all in the database(fact) as well, then it gotta say "yes", otherwise "no". The predicate obviously…
mkll
  • 41
  • 9
0
votes
2 answers

Prolog - Exercise on facts and lists

The problem is that I need to program a predicate capable of consulting the products in a database so that it returns a list filled with the names of the products its prices are reduced(that is indicated by the "state". domains state = reduced…
mkll
  • 41
  • 9
0
votes
2 answers

Prolog - Little exercise on facts

Ok. That's my problem. I need to implement a predicate that sums up all the prices of the products in the list. But, for now, I'm not getting any further with it. What am I doing wrong? Thanks in advance. domains state = reduced ;…
mkll
  • 41
  • 9
0
votes
3 answers

Prolog - Insert with facts

I need to program a Predicate in Prolog that inserts an element in the indicated position and consequently modifies the position number of the rest of the elements in the list. What I've achieved is the next snippet of code that implements a…
mkll
  • 41
  • 9
0
votes
1 answer

I am not able to get dimensions and fact values while browsing cube in SSAS 2005

I am new to SSAS. I have two tables, FactAnswers and DimDebit. one dimension and one fact. After creating cube when I try to browse dimensions and fact, I got nothing. I want to get AnswerValue from fact table and Debit values from Dim table.…
user999896
  • 129
  • 2
  • 6
  • 21
0
votes
1 answer

JBMRS: Creating Facts

Which one will be better for a project using JBRMS, JBPM inside an ESB: Creating fact types inside the BRMS or uploading POJO's? As per my understanding, creating fact types inside BRMS have advantage like, if there is anything to be added later on…
aps
  • 21
  • 7
0
votes
1 answer

Alloy fact NOT both properties

I have a piece of code in ALLOY I am trying to do a restaurant reservation system and I have this sig and relation between them. abstract sig Table{ breakfast: one breakFast, lunch: one Lunch, dinner: one Dinner } sig Free{ } sig…
dori naji
  • 980
  • 1
  • 16
  • 41
0
votes
1 answer

Do this fact table alteration change the grain?

The fact table is a weekly snapshot of help desk tickets with 1 row per ticket per week. The ticket dimension contains TicketAgeTarget. I would like to add to the fact table TicketAgeTargetIndicator which is simply 1 or 0 set by the age of the…
DingoCC
  • 159
  • 1
  • 2
  • 12
0
votes
0 answers

Ansible 2.7.9, Registered object split a element in to a dynamic fact(variable)

Struggling with a ansible(2.7.9) playbook. Runnning a remote shell command to encrypt passwords for different DB users and register te output. I only need the stdout and puts this in dymanic variables. When debug this it works great, but to…
user22113861
  • 1
  • 1
0
votes
0 answers

get a slicer to show correctly data from dim table when flittering from a fact table

I have fact table of tickets. There is a field in that table called ownerSK which has the owner of the ticket. This is in the form of there email address. There is also a dim table called Employee which has ownerSK and EmployeeName. This table is…
Adrian lock
  • 3
  • 9
0
votes
0 answers

Ansible - create dictionary from pair of Fact attributes

I'm trying to combine a servers Hostname and Cluster attributes from the servers facts into a dictionary so that I get hostname:cluster When i have the hostname:cluster pairs for a number of servers, i'd like to group them by Cluster. The fact…
piercjs
  • 133
  • 8
0
votes
0 answers

Using EMR or Databricks Pyspark , Update existing records in large fact tables based on dimension update

Fact Table A with total of 50 Billion of Rows. It is an incremental load with 1 Billion rows every month. Due to Dimension Table B change, It requires updates on History data every run leads to Complete overwrite ( 50 B rows ) every time. It…
PeriK
  • 1
0
votes
0 answers

Multiple Fact Columns vs Single Attribute Column

When designing a fact table is it better to use multiple fact columns or attribute and value columns? I am trying to understand which design is more optimum and the reasons behind it.
SeminoleKing
  • 11
0
votes
0 answers

How do i extract certain information from a prolog database of a taxi company?

I'm working with a database or knowledge base, whatever you call it in Prolog. It is filled with facts about clients and jobs of a taxi company: client(id, name, surname, list_of_jobs). The list of jobs is filled with facts in this form: job(from,…
Daki
  • 11
  • 1
1 2 3
…
12 13