applies to: Indyco Builder 1.57 +
A Cross Dimensional attribute can be modeled choosing one the following options:
- Bridge table with surrogates
- Brigde table without surrogates
Bridge table with surrogates
The attribute will be modeled as a bridge table referencing each dimension table using surrogate keys.
In case the surrogate is not present, it will be added to the dimension table.
Bridge table without surrogates
The attribute will be modeled as a bridge table referencing each dimension table using natural keys.
indyco includes lot of best practices and rules from both the academic and business "worlds": to enforce and ensure the best design quality of your data warehouse, indyco will automatically detect conditions where only one option is viable and applies it.
When a cross-dimensional attribute depends on attributes belonging to the same hierarchy, it will be modeled as a standard attribute: it will be added as a column to the dimension table.