Answered On : 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 tableFurther consider the scenarioFact1
Answered On : Feb 1st, 2008
Resolving fan trap: alias and resolving chasm trap: context is used
Copyright © 2024 GeekInterview.com | All Rights Reserved
Copyright © 2024 GeekInterview.com | All Rights Reserved