content_dim:

id              content_name  owner
===================================
1               xxx           foo
2               yyy           foo
3               zzz           bar


location_dim:

id               cc    rn   cn
==================================
1                se    08   sthlm
2                se    031  gbg



staging:

content_name    cc rn cn      bytes
================================
xxx             se 08 sthlm   12121
xxx             se 031 gbg    43213


  TRANSFORM TO


data_fact:

content_sk    location_sk      bytes
====================================
1             1                12121
1             2                43213