Get group key from bridge table
- by Mads Jensen
I'm developing an ETL process, and need a bridge table for a one-to-many relationship between a fact table and a dimension table (MySQL database). There is a limited number of combinations (some thousands), so I want to re-use group keys from the bridge table to to limit the size.
Any group of dimensions belonging to a fact row will consist of a…