I've been searching everywhere for the past two days without success and decided to post my question here.
I'm building a data wharehouse for a course and I'm having some trouble.
The facts are flights which have a time, airplane, origin_airport, dest_airport, origin_climate and dest_climate dimensions.
On another unrelated question, how should I proceed with populating the data warehouse? Should I populate all dimensions and add the facts later or try and insert each fact and if its dimension value doesn't exist, I add them first (to get the foreign keys) and then add the fact. I don't which way is better and also which components to use (one which allows the primary key to be the result of a sql query?)