Wednesday, May 09, 2012 7:56 AM
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.
Wednesday, May 09, 2012 6:38 PM
You can do it in two ways.
1. update the dimension automatically befor Fact load
2. Use view as a dimension
Thursday, May 10, 2012 4:28 AM
Could u eloborate briefly with somee example
Thursday, May 10, 2012 2:05 PM
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.
- Marked As Answer by Challen FuModerator Sunday, May 20, 2012 3:42 PM