Scenario: Bridge Table for Many-to-Many Attribution

Marketing wants campaign attribution where one order can map to multiple touchpoints. Design dimensional approach with performance in mind.

fact_orders(order_id, amount, date_sk), bridge_order_touch(order_id, touch_id, weight), dim_touch(touch_id, channel)