Populating Bridge Tables Technics

View previous topic View next topic Go down

Populating Bridge Tables Technics

Post  mar78 on 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.

mar78

Posts : 3
Join date : 2010-02-14

View user profile

Back to top Go down

Re: Populating Bridge Tables Technics

Post  ngalemmo on Tue Mar 30, 2010 1:06 pm

avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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