Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Populating Bridge Tables Technics

Go down

Populating Bridge Tables Technics Empty Populating Bridge Tables Technics

Post  Guest Tue Mar 30, 2010 2:58 am


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.


Back to top Go down

Populating Bridge Tables Technics Empty Re: Populating Bridge Tables Technics

Post  ngalemmo Tue Mar 30, 2010 1:06 pm

Yes, you do it first.

The mechanism to build multivalue dimension bridge is discussed in

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum