(Kubilay) Chasm trap in data warehouses occurs when two fact tables relate into one dimension table. This is a data modelling problem which will cause double-counting and bad data when these tables are joined. SQL and relational databases surprise me every day!
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help