Load a fact with a related large dimension

Purpose

Unmatched dimensional member processing in the fact delivery requires the whole dimension be cached in memory. This can cause memory allocation errors with large dimensions. To alleviate this problem, the reference between the fact and the dimension in the target model can be removed. Instead, a dimension business key is manually added to the fact and when the fact is loaded a new relationship is created in the Target Framework Manager Model to relate the fact to the large dimension.