Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [facttable]

53 questions
8
votes
2 answers

Is my understanding of Fact table granularity correct?

Myself and another DBA at our company are tasked with reviewing a database design that a vendor has developed for us. The vendor has said they use Kimball as the basis for their design. (NOTE: I am not looking for arguments of Kimball vs Inmon,…
Chris Aldrich
  • 4,916
  • 5
  • 34
  • 55
8
votes
4 answers

How do you roll up header-level values on a fact table with line-item granularity?

From what I've read, the recommended granularity for a fact table based on an order header / line item structure is at the line item level. In the process, any additive values that apply only to the order header are repeated for each line item:…
8kb
  • 2,639
  • 2
  • 32
  • 36
7
votes
3 answers

Header and line item data source mismatch

I'm working with a star schema for a data warehouse and I am running into a problem with header and line items from different data sources. CREATE TABLE DataSourceAHeader ( OrderId INT NOT NULL ,TotalCost MONEY NOT NULL -- Date,…
Dustin Kingen
  • 73
  • 9
5
votes
2 answers

What is the difference between bridge table and helper table in data warehouse's context?

From what I could understand :- Bridge tables are used when a dimension table can not be directly associated with a fact table. e.g. In a bank's data warehouse a fact table of balance of a customer can't be stored with a customer ID as link between…
aarushi
  • 153
  • 1
  • 1
  • 3
5
votes
1 answer

If a DW fact table is not uniquely identified by all dimensions, what problems?

This is a bit of a thought problem I've been wrestling with. I have a visceral antipathy to the notion of duplicate combinations of dimension values in a fact table. I've read a lot about the existence of problems when the combination of…
Andrew Wolfe
  • 584
  • 5
  • 16
4
votes
2 answers

Open source and commercial tools to build dynamic queries of fact tables in star schema

What user interfaces or tools (commercial and/or open source) can query a star schema model (Ralph Kimball dimensional model)? So for example, if we have X fact tables, and Y dimension tables, and Z cross reference tables, we'd like to query a…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
4
votes
2 answers

When to choose an attribute vs. a new dimension?

I am fully aware of what is a fact, attribute and dimension. However, I'm quite confused to which traits I should choose for dimensions vs attributes of that dimension. For instance, I'm building a hospital data warehouse and gender could be a…
LearnByReading
  • 711
  • 10
  • 26
3
votes
1 answer

Dimensional Modeling of a Loan Approval Process and Fact Grain(s)

Context: I'm modeling for a lending company and I'm modeling our loan approval process. I have some basic dimensions relative to our business figured out: Time(day) Account Opportunity Channel And I and getting to the modeling of fact…
Bee-Dub
  • 41
  • 5
3
votes
1 answer

Does surrogate key assignment for a fact table require that the source data has natural keys?

Let's say I have a simple OLTP database with orders, products, and customers: And from it, I am building a data mart with an orders fact table, product dimension, customer dimension, and date dimension: When loading the orders table into…
8kb
  • 2,639
  • 2
  • 32
  • 36
3
votes
0 answers

An advice to design a fact table with a scd as a dimension

I have a problem of conception and I would like to get your ideas on how I'll be able to do what I am aiming. My goal is to create a datawarehouse, with three dimensions and one fact table so far. Dimensions : Tasks (id, name, status - 0 or 1…
Spredzy
  • 2,248
  • 2
  • 20
  • 25
2
votes
3 answers

Data Warehouse measures without a corresponding dimension

I have an operations database that contains this table: salesQuality salesPrice salesCategory According to my business requirements, the salesQality and salesPrice are measures. However, salesCategory is a dimension. Unfortunately, in the…
Marco Dinatsoli
  • 151
  • 5
2
votes
1 answer

Conceptual Design of a data warehouse (declaring the grain)

I am trying to design a data warehouse using this example scrubbed data. I need to declare the "grain". I know its the lowest level of detail in the fact table, but I am having a hard time determining it. Any help would be appreciated. (Sorry about…
Johnny Holmes
  • 325
  • 1
  • 2
  • 6
2
votes
2 answers

Data warehouse support tickets

I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows Now one of the questions we want to ask is historically how many…
Alan Hollis
  • 123
  • 1
  • 6
2
votes
1 answer

Design of fact table(s) and dimensions tables for data warehouse

Hi i'm newbie in Datawarehousing, how would you model this in a Data Warehouse: i wish design the Data Warehouse which give the answers of statistics relating to a baseball league For players in offensive: •How many times has a batter to bat. •How…
franvergara66
  • 121
  • 3
2
votes
1 answer

Dimension modelling for HR with Employee Dimension and multiple departments in a Data warehouse

What is the best way to configure a dimension model (preferably star schema) when we have the following requirements? There is an Employees table (25 attributes) where we are required to make some of the attributes to SCD2. For e.g. Salary,…
Irfan Gowani
  • 21
  • 2
1
2 3 4