Treating the Many-to-many relationship data objects in DWH

[AshishVinny]

WHat is the best way of representing a many-to-many relationships on multiple entities in DWH. Each entity is being converted into a dimension.

The only transactions in the source application are about many-to-many relationships between entities in the source environment - ASSET Management Application (For : Servers, Laptops, Monitors, Printers etc)........

If I treat the relationship table into a factless fact table, is it a goodidea?

Ashish.

 

[johnherman]

Use the bridge (aka relationship or associative) table as the dimension.

Sometimes the grass is greener on the other side because there is more manure there - original.