In the Advanced Reporting tool, you want to create a query where the results meet the following criteria
* Only show one row per employee,
* Only show the pay components Base Salary and Bonus,
* Show these pay components as individual columns.
You have joined the Global Job Information table with the Compensation table.What else must you do?
Note: There are 2 correct answers to this question.

Question

In the Advanced Reporting tool, you want to create a query where the results meet the following criteria

* Only show one row per employee,

* Only show the pay components Base Salary and Bonus,

* Show these pay components as individual columns.

You have joined the Global Job Information table with the Compensation table.What else must you do?

Note: There are 2 correct answers to this question.

Rosalba Scalera · Accepted Answer

Configure a table restriction of the Compensation table.

Rosalba Scalera · Accepted Answer

Configure a table restriction of the Global Job Information table.

Rosalba Scalera · Answer

Duplicate the Compensation table.

Rosalba Scalera · Answer

Change the table join to the Compensation table to an inner join.

List of questions