Handling concurrent inserts in dimension tables.
Implementing dimension table indexing strategies.
Techniques for handling alternate hierarchies in dimension tables.
Handling dimension table updates in data federation scenarios.
Implementing type 1 slowly changing dimensions.