Database Tutorial

Course Tutorial Site

Site Admin

Description

without comments

Lab #12: Selective Aggregation

Learn how to use the CASE operator with aggregation functions to transform and report data. This type of approach is known as selective aggregation.

Lab Description

Learn how to use the CASE operator with aggregation functions to transform and report data.

The lab has four parts, which you find after clicking on the Lab Instructions link. The steps are:

  • Step 1: Create the calendar table as per the specification provided.
  • Step 2: Seed the calendar table as per the specification provided.
  • Step 3: Create a transaction_reversal table that imports a transaction_upload2.csv file from the upload virtual directory; and transfer the data from the transaction_reversal table to the transaction table by using an INSERT statement.
  • Step 4: Create the following transformation report by a CROSS JOIN between the transaction and calendar tables.

Written by michaelmclaughlin

August 13th, 2018 at 12:02 pm

Posted in