Transaction analytics
— Q2 · Q5 performance queriesPerformance queries — star join · window function
Q2 — f_transaction → d_time · Q5 — f_transaction → d_time → d_company · cumulative window
Q2 groups by fiscal quarter and currency — tests multi-column grouping on a dimension table.
fisc_quarter is pre-computed on d_time, no date_trunc needed.
Q5 computes cumulative revenue per company per day using a window function
(SUM OVER PARTITION BY c_id ORDER BY day_bucket). Most sensitive to index availability on d_time.
Transaction volume & cumulative revenue
f_transaction · d_time · d_company