Yeah, I may have messed the terminology here, depending on the dataset, the dimension tables can be close to the fact table in cardinality, for true flexibility, it degenerates into a fact table with just a record id and dimension tables with a FK to the fact table and a single column.
If the DB is a true columnar store, there's no need to do that, but most are record based.
If the DB is a true columnar store, there's no need to do that, but most are record based.