I am building the data warehouse based on the star schema and I've got difficulties with one issue as follows:
I have a dimension "Manufacturer" that can have several brands in his production line. And of course one brand belongs just to one manufacturer. The dimension "Brand" cannot be created.
How can I display it in my star scheme?
Usually in a star scheme the aggregation level is represented as an attribute according to just one unit/piece. But in our case one Manufacturer has several units. I thought that a bridge table will be a solution for that, but bridge table is more for many to many relationships (as one producer - many brands, one brand - many producers), but in our case it looks otherwise.
Please help to solve this issue. Thanks! :)