Posted On: Apr 01, 2020
The chasm trap is created when the values in the fact tables get inflated. This condition arises in the dimensional schema-based universe because in this we have the only one-dimensional table which is joined with two fact tables. So, when we drag a measure from both fact tables and also dimensions from the dimension table, the value of flat tables that is measured gets inflated. This situation is known as a chasm trap.
Two methods to solve the chasm trap:
Never Miss an Articles from us.