StackOverflow Questions for Tag: star-schema

A. Romain

Reputation: 29

In a Star Schema, can a fact table Foreign Key be associated with multiple dimension columns?

sqldatabaseforeign-keysstar-schema

Score: 0

Answers: 1

xandor19

Reputation: 53

Multidimensional model with interrelated dimensions?

databasedata-warehousebusiness-intelligencestar-schemamultidimensional-cube

Score: 0

Answers: 0

jophuh

Reputation: 317

This Star Schema is Exactly Backwards, how do I correct it?

sqldatabase-designdata-warehousedimensional-modelingstar-schema

Score: -2

Answers: 0

Alessandro

Reputation: 337

Time Dimension: loading date

data-modelingdata-warehousestar-schema

Score: 0

Answers: 1

GuggeSthlm

Reputation: 3

Importing an exisitng BI solution to my own BI solution. How to go about it?

t-sqlbusiness-intelligencedimensionsstar-schemafact-table

Score: 0

Answers: 0

Calanus

Reputation: 26317

Data Warehousing - Star Schema vs Flat Table

data-warehousestar-schema

Score: 31

Answers: 3

Muhammad Aitazaz Kamran

Reputation: 1

How to link suppliers and products as separate dimensions in a data warehouse when only product ID is present in transactions?

data-warehousestar-schemastar-schema-datawarehouse

Score: 0

Answers: 0

Maokai

Reputation: 224

Determining the Appropriate Grain for a Pharmacy Consultation and Prescription Fact Table

data-modelingdata-warehousebusiness-intelligencestar-schemakimball

Score: 0

Answers: 1

STKVE

Reputation: 3

Joining measures from two fact tables

powerbidaxpowerquerystar-schema

Score: 0

Answers: 0

BillGrant

Reputation: 1

Slowly Changing Dimensions - capture for ETL to a Dimensionalised Data Warehouse

etlstar-schemascd2

Score: 0

Answers: 0

ninelondon

Reputation: 149

Power BI Data Modelling - select dish based on the ingredients available

powerbidata-modelingstar-schema

Score: -1

Answers: 1

Nolann Salaun

Reputation: 3

Is this star schema model valid or does it required updates to be more efficient?

powerbidata-modelingstar-schemaoracle-sql-data-modeler

Score: 0

Answers: 0

variable

Reputation: 9724

Should sales order number and purchase order number be placed in FactOrder table or should it have its own dimension?

data-modelingdata-warehousedimensional-modelingstar-schemastar-schema-datawarehouse

Score: 0

Answers: 2

user3195568

Reputation: 137

Star schema - splitting dimensions into multiple smaller dimensions

data-warehousedimensional-modelingstar-schemakimball

Score: -1

Answers: 3

Anatolii Kyrychenko

Reputation: 1

DW/ BI dimension modelling, combining facts

data-warehousestar-schemalookerdimensional

Score: 0

Answers: 1

Ajility

Reputation: 567

Setting up Time Dimensions for Resolutions in a Star-Schema

database-designdata-warehousestar-schema

Score: 3

Answers: 1

Bala

Reputation: 21

Can we create a dimension model without surrogate keys

data-warehousebusiness-intelligencedimensional-modelingstar-schemadata-lakehouse

Score: 1

Answers: 0

subzerowitch

Reputation: 1

How to make Star Schema having 2 Fact Tables?

schemapowerbi-desktopstar-schema

Score: 0

Answers: 1

variable

Reputation: 9724

How to model when header table has values?

powerbidaxpowerbi-desktopdata-modelingstar-schema

Score: 0

Answers: 2

ninelondon

Reputation: 149

How to deal with changes in Power BI dimension tables?

powerbidatamodelstar-schema

Score: 1

Answers: 1

PreviousPage 1Next