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
1
vote
2 answers

How Many Ways are There to Order the Letters of a Word using google sheets

Determine the number of distinct ways to arrange the letters for each word in the range A1:A18. Input Desired…
Osm
  • 2,699
  • 2
  • 4
  • 26
1
vote
1 answer

Ansible: filter an item from a list of object in a json file

I have in ansible the following code: --- - name: "Retrieve ID for group {{onboarding.repo.subGroup}}" uri: method: GET return_content: yes validate_certs: "{{gitlab_validate_certs}}" url: "{{ gitlab_api_url…
Giorgio
  • 11
  • 2
1
vote
1 answer

Ansible adding items to nested list

starting data: ok: [test@test.com] => { "msg": { "testdb1": { "dbe_user_not_in_db": [ "test_user1", "test_user2" ], } } } I currently have the following in ansible: …
user2763181
  • 11
  • 2
1
vote
2 answers

how i can use hashSet in Theory inlinData

I have a test class and I want write a test for one of my functions and I have to use HashSet in [Theory] inlineData but I can't use it. [Theory] [InlineData(new HashSet() {"text1","text2"}, "str")] public void…
N Th
  • 35
  • 5
1
vote
2 answers

Combining additive and semi-additive facts in a single report

I'm working on a quarterly report. The report should look something like this: col Calculation Source table Start_Balance Sum at start of time period Account_balance Sell Transactions Sum of all sell values between the two time…
Anton
  • 581
  • 1
  • 5
  • 23
1
vote
1 answer

Data Warehouse Fact Constellation schema

I have two fact tables one depend on date date dimension (Day,month,year). and the other depend on month and year only. So my question do i need to create two dimension one has (day month year) and another dimension that only has year and month…
andy
  • 47
  • 5
1
vote
1 answer

Ansible set_fact Nested Variables in Playboook

I've been working on this problem for a while and can't find a solution. My playbook is: - hosts: localhost connection: local gather_facts: False vars: vpc_stack_name: "VPC-CF" tasks: - name: Get summary information about a stack …
Txynidakis
  • 21
  • 5
1
vote
0 answers

Storing and querying heteregenous facts|rules in outside store?

What is the best way to store and query heterogeneous facts and rules in DB or other store . For example : https://www.swi-prolog.org/pack/list?p=db_facts allows you to store homogeneous facts where you have to create table for every different…
sten
  • 7,028
  • 9
  • 41
  • 63
1
vote
1 answer

Do i need a time dimension for my fact table to prevent duplication?

I am designing a Data Warehouse and need some help with my fact table. My fact table is capturing the facts for aged debt, this table captures all transactions against bills. The dimension keys i have are listed…
cherylberyl
  • 13
  • 2
1
vote
2 answers

Catch exception in xunit test

Can I catch the exception that appears in the log but not in the test? I performed the test and it returned the status: OK, but in the log I have: Unexpected error publishing create package to Kafka. id = 5ec3eb81aa662c8a7c76e5e8. Exception:…
Beret
  • 11
  • 3
1
vote
1 answer

prolog - create list from facts by criteria

I'm trying to create list from the facts in SWI-Prolog. There are amount of exapmles but I don't understand how to create list by criteria. You can see my code below. Predicate extract doesn't work as I expected. I need: L = [depos(sbr, 3000, 3),…
gorshkov
  • 67
  • 6
1
vote
1 answer

What is meant by fact values or measure in fact table?

I have strong confusion with fact values, is it derived directly from OLTP by ETL mechanism into fact table & then we need to perform aggregate function to get summarized that by throwing queries? Or it is nothing but summarized value that we get…
rushikesh ayati
  • 17
  • 1
  • 6
1
vote
1 answer

How to model a dimension table that link to several facts with different level of grain?

I have a fact that store client's address. Problem is, the client can choose to insert information at state level, or county level, or street level. In the operation database, there is 1 table for streets, link to another table for counties, link to…
DreamingFighter
  • 41
  • 5
1
vote
0 answers

Performance improvement by selective updating of Fact table columns in dimensional data warehouse

I'm trying to improve the loading of a dimensional data warehouse. I need to load tens of thousands of records each time I run the loading operation; sometimes I need to load hundreds of thousands of records; semi-annually I need to load millions…
BRW
  • 187
  • 1
  • 10
1
vote
2 answers

SSAS Tabular model: two relations with the same dimension table

I need to create a tabular model with ssas but in a fact table I have two relations with the same dimension (time). How is it best to handle this? Duplicating the dimensions table ? Thanks
power83
  • 69
  • 8
1 2
3
…
12 13