In snowflake model, there is only one fact table also. But you could define lookup table joins with another lookup table.
If the query pattern between your two "fact" tables is fixed, just like factA left join with factB. You could define factB as lookup table and skip the snapshot for this huge lookup table. With Warm regards Billy Liu 高扬02 <[email protected]> 于2018年10月18日周四 上午11:36写道： > > Kylin 2.5. > > How to define a snowflake model ? I did not find the place to set it. > > I have two fact tables , now I must create two cubes , and query “cube join > cube”. > > To query the raw data of the measure column for “join” sql ,Now I set the > measure column to be the dimension column also,because it takes too long to > use the “query-push-down”. > > Please show me where to define a snowflake model. > > thanks.
