InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is Chasm trap? How do you resolve this? |
|
Answer» When you join a dimension table with two fact tables with one to many relationship, when you drag a dimension along with measure from both the fact tables, value of measures are inflated. This is called Chasm trap. This can be solved using Context by creating two different contexts. Other way is to go to Universe parameters and select the check box → Multiple SQL statements for each measure |
|