Hello Experts,
As per my understanding of Fan Trap, if 3 tables are joined by 1:M relationship (1:M fan out in 1:M) and if we are taking measures from any 2 tables, then there is a potential Fan trap scenario.
Consider if there are 3 dimension tables with 1:M relationship or if there are 2 dimension tables and 1 fact table and measure is taken from any 1 table, then does Fan trap scenario comes in to picture?
Any guidance in above scenario is appreciated.
Regards,
Chinmay