The surrogate key problem nobody plans for
Sooner or later every data warehouse needs surrogate keys. You are building a dimension table and you want a single narrow column your fact tables can join on instead of a wide composite of source attributes...
