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.
在这两种情况下,考虑在伪事实表的连接表达式中添加额外的逻辑,这会缩小从维度表返回的连接键值的范围。
MDC automatically defines a cell (and creates blocks to store data for that cell) for each unique combination of MDC dimension values.
MDC则为每种惟一的mdc维值组合自动定义一个单元格(并创建块来存储那个单元格的数据)。
Given a dimension, you have three wGrow values to consider: two of the sides (left and right, or top and bottom) and the child's value itself.
对于一个给定的维,有3个wgrow值要考虑:两个边(左和右,或者上和下)和child值本身。
应用推荐