Skip to main content
Database Administrators

Questions tagged [star-schema]

Ask Question

The tag has no summary.

58 questions
Newest Active Bountied Unanswered
1 vote
0 answers
35 views

I am designing a snowflake (star, constellation) schema to model a questionnaire enabling aggregation of questions. A template can have multiple questionnaires. A questionnaire can have only one ...
Bennimi's user avatar
  • 165
0 votes
0 answers
103 views

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 ...
brahmana's user avatar
  • 101
1 vote
0 answers
197 views

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 ...
Arxz's user avatar
  • 11
0 votes
1 answer
82 views

I'm working a star schema data warehouse created in Azure SQL database where the last developer included WITH RECOMPILE on all the Procs. This I believe was because the ETL only executes these Procs ...
Geezer's user avatar
  • 513
0 votes
1 answer
185 views

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 ...
ShayD's user avatar
  • 1
1 vote
0 answers
201 views

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 ...
CandleWax's user avatar
  • 73
0 votes
0 answers
1k views

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 ...
Trelaquix's user avatar
  • 1
-1 votes
1 answer
493 views

I have large fact table, and a much smaller dimension table in a simple star schema: --1. CREATE TABLE dbo.Dim ( Id INT NOT NULL IDENTITY PRIMARY KEY CLUSTERED, CustomerName VARCHAR(2000) ) --index ...
Avi's user avatar
  • 265
2 votes
1 answer
1k views

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 ...
Irfan Gowani's user avatar
  • 21
1 vote
1 answer
2k views

I am new to data warehouse modelling so please bear with me. In database warehouse modelling, the star schema is typically a fact table with multiple dimensions connected directly to it. However, what ...
user3118602's user avatar
  • 147
1 vote
1 answer
192 views

According to Kimball: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/outrigger-dimension/ A dimension can contain a ...
d11wtq's user avatar
  • 185
1 vote
2 answers
1k views

I am modeling a star schema for user reviews using the yelp data set. Each user review has a business dimension key, user dimension key and a bunch of data associated with the review. All of the ...
bfmcneill's user avatar
  • 13
0 votes
0 answers
206 views

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 ...
Dave Copeland's user avatar
  • 1
0 votes
1 answer
259 views

I need to solve an exercise for a pharmaceutical company, they ask me to create a database structure from scratch given a few informations. Because I want it to be scalable and "future proof"...
Francesco Mantovani's user avatar
  • 1,705
1 vote
1 answer
453 views

I am a newbie and would appreciate suggestions/material to research I have 3 types on information in a single table problems reasons fixes problem data is related to reasons by 1 to many reasons ...
user2543622's user avatar
  • 119

15 30 50 per page
1
2 3 4