QuestionQ73
VerifiedData Operations and SupportA company uses Amazon Redshift to store order transactions for the current day. The company has an orders table that contains prior order data. The company also has a staging table that holds new or updated order records.
The company must remove stale records from the orders table and insert the most recent data from the staging table into the orders table. Several downstream applications require the orders table to show up-to-date information.
Which solution meets these requirements?
Community Discussion