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. 


 



Automatic choices

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 platform, 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.