Here is what is going on at House-O-Pets: you have just set up a data warehouse system that contains copies of all your customer transactions in several new partitioned tables. You want to update all the warehouse customer records with a timestamp to record when you added the records into the data warehouse. You also want to run a parallel query on the customer object table that sorts customers by their purchase amounts.
Starting with the code in your downloaded file, modify the file to complete these tasks:
- Add a parallel update of the
CUSTOMER table. Update the WAREHOUSE_DATE column with the current date and time.
- Add a
MAP METHOD function called
HIBUY to the
CUSTOMER_SALES that returns the TOTAL_SALE_AMOUNT column.
- Add a parallel query on the
CUSTOMER_SALES object table that lists the customer’s name and purchase amount, sorted by the
MAP METHOD you created.
Submitting your exercise
Type (or cut and paste) your plan into the box below to submit your answers .
Click the Submit
button when finished to submit the exercise.
Remember to submit all of your answers at once.