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

create fact table in sql using materialized view

I have 4 dimensions ('T_DATE', 'CUSTOMERS_COPY', and 'ORDERS_COPY') and I'm trying to create a fact table so far this is what I got but I got an error ( ORA-00904: "ID_C": invalid identifier ) any one have any Idea ?? CREATE MATERIALIZED VIEW…
amal
  • 1
0
votes
1 answer

Populate Dim and Fact Table from Source Table which already has a Natural Key

I have a Source Table which looks like as below (pls focus on the show_id column) [ And below is the Dim and Fact Table Diagram from my school's guide: They put the show_id from the Source Table directly inside the Fact table, which confuses me. I…
Hoang Minh Quang FX15045
  • 733
  • 1
  • 4
  • 15
0
votes
0 answers

Fact and Dimension Relational Model Snow Flake Schema

Click to See Summary of two datasets How to create fact and dimension tables with Sales data frame from Daily Target data frame
alextim
  • 1
  • 1
0
votes
1 answer

Can observations in a fact table also be dimensions?

My understanding is that a fact table uses keys, which are dimensions that ought to have their own dimension table, to identify observations and assign them values. Can these values themselves be dimensions? Or does that violate some principle of a…
J. Mini
  • 1,868
  • 1
  • 9
  • 38
0
votes
0 answers

Replacement with regex

I tried to trim the custom facts but it will not give me expected result. My entire code as below. --- - name: Extarcting the Value hosts: localhost gather_facts: no connection: local vars: app_brach: onkar-test …
omankame
  • 59
  • 5
0
votes
2 answers

Data warehouse: difference between semi-additive and non-additive measures

I have some difficulty to understand the difference between semi-additive and non-additive measures in a fact table. I've seen this example: What's the difference between additive, semi-additive, and non-additive measures But I don't understand it.…
user2205174
  • 41
  • 8
0
votes
1 answer

DWH modelization - Relationship between 2 fact tables

Hy, I realize a DWH and i have a probleme with the relationship between my tables. My context : "job offer" : contains the list of all job offer. A job offer is created by a company, have a validation date and can be publish to a jobboard (like a…
Maxence Leurquin
  • 1
0
votes
0 answers

How can we connect a junk dimension to the whole dimensional model without snowflaking or increasing the size of one of the dimensions?

I have a fact table holding keys of a field, observation, and date. The fact grain is one row per field value. The field dimensions holds information on the field itself (type, system name, label...). Usually the type should be number only as the…
alim1990
  • 4,656
  • 12
  • 67
  • 130
0
votes
1 answer

Not sure whether to model Tickets as a Fact or Dimension

I have a source with information about TICKETS and about TIME_ENTRIES. Initially I wanted to model TICKETS as a fact table with measures like first_response_time, resolve-time, and with dimensions like Requester/company, Agent/-group, start-date,…
Bart Jonk
  • 365
  • 3
  • 14
0
votes
1 answer

resolve the ambiguity for the dimensional model for one to many(fact to dimension) ratio

I have a question regarding facts and dimensions. suppose I have come across a fact table fact_trips - composed of columns like trip_id , driver_id, vehicle_id, date ( in the int form - 'YYYYMMDD') , timestamp (in milliseconds - bigint…
AdityaT101
  • 51
  • 1
  • 6
0
votes
1 answer

The ambiguity w.r.t date field in Dim_time

I have come across a fact table fact_trips - composed of columns like driver_id, vehicle_id, date ( in the int form - 'YYYYMMDD') timestamp (in milliseconds - bigint ) miles, time_of_trip I have another dim_time - composed of columns like …
AdityaT101
  • 51
  • 1
  • 6
0
votes
1 answer

How to dynamically reload rules using already declared fact types?

I am facing an issue while trying to reload rules dynamically. Starting with the context : we have DRLs files which contains a total of 10000 rules, and various types. As the process of compiling and redeploying rules is starting to be long (over…
ipingu
  • 307
  • 1
  • 5
  • 13
0
votes
2 answers

Table Schema with multiple columns in fact table referring to one column in dimension table

To start off, I am creating a table schema in Power BI with the use of R to wrangle all of my data. Here is a simple example of my issue. I have a table with ID numbers and several demographics related to each ID. In this case, you'll see 3…
abet
  • 175
  • 1
  • 8
0
votes
1 answer

Designing a DW Model Diagram

I am tasked with modeling out a rough design of a DW. Main purpose is for searching property information and files, orders that are opened on said properties. I am struggling with the structure when it comes to A File(Parent level transaction) and…
Netta G
  • 53
  • 1
  • 5
0
votes
0 answers

Tableau dimension lookup for performance

I have a fact table that has several dimension keys from the same dimension like a sales_fact with customer_key, manager_key or sales_rep_key all coming from the party_dimension. ... and the join keys are different party_dimension.party_key =…
Venu Family
  • 83
  • 1
  • 4
1 2 3
…
12 13