Hi

I have a qustion regarding DWH design and ETL processes.

Let´s say I have a fact table call sales, a time dimension which is a calendar year with granularity up to hours with surrogate key from 1 to 8760 (8760 hours per year).

In a ETL process how would you load this surrogate key in the fact table? In a procedural approach, to load 10 million rows 10 million queries would needed to run against the dimension table. Is this the proper way to do it?