Detecting a Chasm Trap

You can find chasm traps by using Detect Contexts to detect and propose candidate contexts, and then examining the table where any two contexts diverge. This point where two contexts intersect is the source of a chasm trap. If you have two fact tables with many to one joins converging to a single lookup table, then you have a potential chasm trap.

Note.pngFor information on organizing the table schema to detect join problems, refer to Detecting Join Problems Graphically.