Data Services has a standard set of functions available to perform mathematical operations. In this recipe, we will use the most popular of them to show you what operations can be performed on numeric data types.
Create a new job and name it
Job_Math_Functions
.Inside this job, create a single dataflow called
DF_Math_Functions
.Import the
FactResellerSales
table in your DHW datastore and add it to the dataflow as a source object.Add the first Query transform after the source table and link them together. Then, open it and drag two columns to the output schema:
PRODUCTKEY
andSALESAMOUNT
. Specify theFACTRESELLERSALES.PRODUCTKEY = 354
filtering condition in the WHERE tab:Add the second Query transform and rename it
Group
. Here, we will perform a grouping operation on the product key we selected in the previous transform. To do this, add thePRODUCTKEY
column in the GROUP BY tab and apply thesum()
aggregate function onSALESAMOUNT
in the Mapping tab:Finally...