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?)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.