Questions tagged [star-schema]
The star-schema tag has no usage guidance.
16
questions with no upvoted or accepted answers
5
votes
2
answers
1k
views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
- 231
3
votes
0
answers
138
views
Store email in a separate Dimension or in a Degenerate Dimension?
I just started learning about dimensional modeling and I am creating a star to analyse email newsletter signups for an online business.
I have a fact table that records the signups and links to a ...
- 131
3
votes
0
answers
2k
views
How to insert values into Bridge Table in star schema?
I am modelling my database with respect to star schema with bridge tables.
My master Table looks like below. I need to convert this format to star schema.
MasterTable
StudentNumber | Subject1 | ...
- 31
2
votes
1
answer
655
views
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 ...
- 21
1
vote
0
answers
95
views
Data warehouse: solving many-to-many relationship with duplicates
I'm learning dimensional modeling and have a question.
I understand those basic examples such as a FactSale has DimItem, DimLocation.
But when it comes to complicated cases with many-to-many ...
- 11
1
vote
0
answers
167
views
Star Schema design considerations
We receive patient data that includes case level info (hospital id, patient id, length of stay, surgery date) as well as surveys/educational material that the patient completed as well as their ...
- 73
1
vote
0
answers
303
views
Star schema with both many-to-many relations and inheritance
The problem
I am trying to make a star schema of the following situation, concerning transactions on a stock market. I have summarized the scenario here:
Each transaction traded on the market has
1 ...
1
vote
0
answers
102
views
Reversing many-to-many relationships when transforming data into a galaxy schema
I'm building a galaxy schema for our analytics and sales data from our normalized data tables. I'm unsure how to treat many-to-many relationships in the facts tables.
For example, for each sale, we ...
- 153
1
vote
0
answers
225
views
Star Schema Design - Multiple Sources
I am planning the design of a star schema for a data warehouse. The data will be loaded from 2 separate staging tables (Client and System).
The end user will need to be able to compare any ...
- 1,394
1
vote
0
answers
821
views
how many fact tables do I need given I want to build an OLAP for Quotation Line Item and Purchase Order Line Item report?
My client wants a report that looks something like this on a daily basis.
+---------------+-------------------------+-----------------+---------------------+-------------+
| ProductNumber | ...
- 175
0
votes
0
answers
22
views
Handling updates in OLAP system for e-commerce system using immutable stores
I have a digital commerce system that we have built in-house and it has been working fine. We now want to implement OLAP to provide our customers with advanced reporting and BI features.
While looking ...
- 101
0
votes
1
answer
125
views
In a star scheme, How to define the fact table when the data has different levels of dimensions?
In a PowerBI project, I need some help to define the fact table/s.
Eventually, I would like to have a nice star scheme to preset some basic visuals as stacked bar etc. to the client.
I'm new to BI and ...
- 1
0
votes
0
answers
738
views
ERD to Star Schema
I have a simple ERD diagram as represented below for a supplier for inventory goods.
What would be the best way to turn this ERD into a Star Schema with one Fact Table and a few dimension tables?
To ...
0
votes
0
answers
181
views
Schema and/or reporting SQL for customer acquisition cost?
This a design question around creating fact/dimension tables to query customer acquisition cost and how to properly model the tables and query them.
Business Rule
We spend some money per day per ...
0
votes
1
answer
2k
views
How to Store a Many-to-Many Relationship Between Fact Tables in a Data Warehouse
What are some structures and models to store many-to-many relational data between two fact tables in a data warehouse? Currently, I am using a mapping table which includes the primary keys from both ...
- 1
0
votes
0
answers
77
views
How to deal with equally growing fact/dimension tables in datawarehouse design?
I have a source data set with:
customer
customer_product_purchase
customer_support_plan_purchase
customer_support_request
All of them have a relationship such that a support request is raised ...
- 131