|
|||||||
| SQL Course SQL Course > Ask questions about the lessons on SQL Course 1 and 2. If you have problems > with the interface, please post in the Feedback forum |
|
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
09-18-2002, 11:34 AM
|
|||
|
|||
OLAP -Populating Fact table
I am trying to poupulate a fact table. The fact table contains foreign keys realted to my dimension tables. I want to move the contents of my dimensions table to a temp table which will then allow me to populate the fact table. Unforunately, I cannot use join or union as the dimension tables do not have any relationships.
Can anyone help or have i got the wrong end of the stick ? 
|
|
#2
09-20-2002, 02:26 PM
|
|||
|
|||
|
Is there any reason that you can't define relationships between the two tables? You mentioned that the "fact table contains foreign keys related to my dimension tables" so you should be able to define the relationship and then use a join.
|
|
|
«
Previous Thread
|
Next Thread
»
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
Linear Mode
|
|
All times are GMT -5. The time now is 12:06 AM.
 |
 |
 |
 |