The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
14 views

Constellation Schema; Relationships between fact tables

What are acceptable types of depedendcies between facts in a multiple-fact schema? Conceptually talking, As you know a Multi-Dimensional Model may have multiple facts (like in a constellation ...
0
votes
0answers
36 views

Greenplum's poor dynamic partition elimination

I have large fact tables in Greenplum with many years of history that are partitioned by a surrogate key (which represents time). Of course almost all queries are for recent time periods where the ...
0
votes
0answers
18 views

ER Studio Data Architect - Deleted relationship in sub model - need to sync up in main model

I have Main Model where I have few entities and relationships. I had pulled out few entities from the Main model into a submodel and was working on the sub model. whereby I had to delete few ...
2
votes
1answer
168 views

Dealing with measure groups of different granularity

Let's say I have a simple data warehouse with the following fact tables: FactPurchase: one row per property purchased, with purchase amount, value, etc. FactMonthlyStatus: one row per property, per ...
1
vote
2answers
124 views

To normalize or not to normalize for few distinct values

Assuming in a Postgres database, you have a table called party, which can have less than 5 well-defined party_types such as 'Person' or 'Organization'. Would you store the party_type in the party ...
0
votes
3answers
97 views

How to solve multidimensional data relationship

I'm having a problem, that I could solve programmatically, but for my personal (test) project I'm trying to see if I can fix it in the relational model. Imagine a complex fashion product Pants with ...
0
votes
0answers
16 views

Many people, one event, multiple factors - OLAP

Have a modeling problem here... first the back-story... We deal with accident data on our project, 1 vehicle-crash can have multiple people and vehicles involved, and many associated factors across ...
0
votes
0answers
62 views

Datamodel design for multiple roles, country access

I am in the process of creating a data model for the below scenario there will be two hierarchies a) dept hierarchy (emp -> team -> dept -> branch) b) sales hierarchy (emp -> marketing manager -> ...
0
votes
1answer
86 views

Type of Foreign Keys for a Dimensional Model Fact Table?

I've been reading about dimensional models, and in particular fact tables, but I haven't really seen one in action (i.e. the actual content), just diagrams of the table structures and column names ...
1
vote
1answer
304 views

Modeling staff dimension in data warehouse

I need to write a data warehouse diagram. I've got a problem with staff area. I have to store a information about workers details like name, age etc., and workers job time and agreement details like ...