New answers tagged data-warehouse
0
This kind of dimension is called Role-Playing Dimension.
This is tipical of Multi-Dimensional SSAS modeling.
However SSAS Tabular modeling does not support role-playing dimensions; you can overcome that limitation by using DAX, enabling inactive relationships for specific calculations (you can define multiple relationships between the same tables in Tabular)...
0
You should specify which database system and version you're using as this will affect your actual choices available for how you structure and manage the data.
You mentioned large in your context means 100,000 new records a day, so let's plan for something an order of magnitude bigger, 1 million records a day. In a month that's 30 million new records, in a ...
0
After some research I've managed to come up with an answer. Kudos to @a_horse_with_no_name for pointing me in the right direction.
Real-time sync between different data sources can be done using Kafka Connect.
Kafka Connect allows to send data from various systems to a Kafka cluster via Source Connectors and read data from Kafka using Sink Connectors. All ...
0
It depends which analytics tools you use on top of your data mart/warehouse. Some of them don't handle bridge table that well (option 2).
My personal preference would be to take both options 1 and 3 at the same time. It's a tiny bit more work when loading the data :
Option 3 requires an extra join/lookup to add the pk of the head dep in the fact table at ...
Top 50 recent answers are included
