Populating Bridge Tables Technics

Hi,

I'm trying to figure out which are the best practises concerning the populating and maintaining bridge tables using ETL tools.

I have a transaction fact tables, and each row of it involves 1 or more rows of Departement dimension table.

I guess i obviously have to load the bridge before loading the fact table, could this be done in the same data flow ?

From above all the possible combinations, how could we determine on the fly, the unique sets for populating the bridge instances and be able to reuse any if the same combination occurs with an other fact.

I'm using SSIS as ETL tool.

Yes, you do it first.

The mechanism to build multivalue dimension bridge is discussed in http://forum.kimballgroup.com/dimensional-modeling-and-data-architecture-f6/how-to-handle-multiple-many-to-many-dimensions-in-a-single-star-schema-t461.htm