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

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.

Guest
Guest


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 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
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top


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