Relationship Issue Between Fact and Dimension

Question

Hi,

     I have a Dimension and a Fact, Daily the data is directly loaded into FactTable only. So, I cant make the relationship between Fact and Dimension. Could u help to make the relationship by adding some rows which are not there in the fact.

I want to create a stored procedure for inserting rows which r not present in Dimension Table with the help of Fact Table using merge Function.

Thanks,

Munna 

Answer 1

Hi Munna,

You can do it in two ways.

1. update the dimension automatically  befor Fact load

2. Use view as a dimension

Thanks

Alex

Answer 2

Hi,

   Could u eloborate briefly with somee example

Answer 3

laod dimensions tables before fact table.

In your case you will have two Stored Procs. the first Stored Proc will load the dimennsion tables. and the second Stored Proc will load the fact table up on the completion of the first Stored Proc.

Alex