While resolving loops, how to decide whether alias or context to be used?

Interview Candidate
Apr 21st, 2007
2
6181

Showing Answers 1 - 2 of 2 Answers

Amandeep

Nov 3rd, 2007

If the dimension table involved in the loop is associated with more than one fact table, then for each fact table, an alias would be required for each dimension leading to a chaos. Contexts are advised in such cases, one for each fact table

Further consider the scenario
Fact1<--Dim1--and fact1<--Dim3--< Dim2
IT results in a loop..vch can be resolved by using a context leading to
Fact1<--Dim1--fact1<--Dim3--< Alias 2

Consider the fact that a new dimension is introduced into the picture having one to one relation wid Dim2 (Alias 1 and alias 2)
IT will again result in a loop as
Fact1<--Dim1--fact1<--Dim3--< Alias 2--
A context would be best in resolving such kind of a loop..