This is a dedicated watch page for a single video.
You are designing a data model in BigQuery for RetailNova , which needs to store retail transaction data. The two largest tables — sales_transaction_header and sales_transaction_line — have a tightly bound immutable relationship , where transactions are rarely modified after being loaded. These tables are frequently joined during analytical queries. To enhance performance for downstream data analysis, how should you model these tables?