Data Model Best Practices
General Best Practices
Whenever possible, name tables after their names in the source system.
Connect tables as you joined them in the transformations.
Only join the case table and the master data for activities to the activity table.
For memory footprint reasons, use tables for data representation with complex logic instead of views.
For performance reasons, only use views of master data tables.
Keep the data model as simple as possible.
Foreign Key Relationships
When connecting tables via foreign keys in a data model, consider:
Tables with a 1:n relationship are correctly joined automatically.
For tables with a 1:1 relationship, the join direction has to be considered for pull functions to work properly. You can only pull from the fact to the dimension table. In the example below, you could only pull from BSEG to LFB1, e.g. PU_COUNT(LFB1, BSEG.LIFNR).
 |