SAP
C_DS_42 · Question #66
You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column). How do you calculate the average salaries for each department in the Query transform in SAP Data…
The correct answer is A. Specify the DEPARTMENT column on the GROUP BY tab. B. Enter avg(SALARY) on the Mapping tab. See the full explanation below for the reasoning.
Question
You have a Salary table containing departments (DEPARTMENT column) and salaries (SALARY column). How do you calculate the average salaries for each department in the Query transform in SAP Data Services?
Options
- ASpecify the DEPARTMENT column on the GROUP BY tab.
- BEnter avg(SALARY) on the Mapping tab.
- CEnter avg(SALARY) on the SELECT tab.
- DSpecify the DEPARTMENT code on the WHERE tab.
How the community answered
(28 responses)- A82% (23)
- C7% (2)
- D11% (3)
Community Discussion
No community discussion yet for this question.