The data engineering team maintains a table of aggregate statistics through batch nightly updates. This includes total sales for the previous day alongside totals and averages for a variety of time periods including the 7 previous days, year-to-date, and quarter-to-date. This table is named store_saies_summary and the schema is as follows:
The table daily_store_sales contains all the information needed to update store_sales_summary. The schema for this table is: store_id INT, sales_date DATE, total_sales FLOAT
If daily_store_sales is implemented as a Type 1 table and the total_sales column might be adjusted after manual data auditing, which approach is the safest to generate accurate reports in the store_sales_summary table?
hammer_1234_h
Highly Voted 8 months, 1 week agoalexvno
5 months agoDef21
3 months, 3 weeks agoThoBustos
Most Recent 1 month agovikram12apr
2 months, 1 week agoRinscy
3 months, 2 weeks agoSomesh512
3 months, 2 weeks agospaceexplorer
3 months, 3 weeks agoRinscy
3 months, 3 weeks agodivingbell17
4 months, 2 weeks agodmov
4 months, 3 weeks agoDef21
3 months, 3 weeks agoLuv4data
4 months, 3 weeks agoalexvno
5 months agoEnduresoul
5 months, 3 weeks agoGulenur_GS
5 months, 2 weeks agoSyd
6 months, 2 weeks agosturcu
7 months agosturcu
6 months, 2 weeks ago