Level 8 - PrincipalOptimization Questionsm4 streaming cdc events
Optimization: DISTINCT vs Window Dedup
Choose better dedup for latest order version: DISTINCT(order_id,status) or ROW_NUMBER partition by order_id.
Choose better dedup for latest order version: DISTINCT(order_id,status) or ROW_NUMBER partition by order_id.