Is there a specification describing the business rules to join key entities such as customer and location?
是否有一个规范来描述连接键实体(例如客户和位置)的业务规则?
In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
在这两种情况下,考虑在伪事实表的连接表达式中添加额外的逻辑,这会缩小从维度表返回的连接键值的范围。
It will also make use of this same primary key to perform JOIN operations when accessing the database.
在访问数据库时,它还会利用同一主键执行join操作。
应用推荐