In the Advanced Reporting tool, you want to create a query that includes the employee's matrix manager. When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers.
How do you configure the query to return one row per employee that shows the employee's matrix manager when assigned?

Question

In the Advanced Reporting tool, you want to create a query that includes the employee's matrix manager. When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers.

How do you configure the query to return one row per employee that shows the employee's matrix manager when assigned?

Maurice Melgert · Accepted Answer

Change the Job Relationship join to an inner join.

Maurice Melgert · Answer

Change the Job Relationship join to a left join.

Maurice Melgert · Answer

Change the Job Relationship to include a table restriction.

Maurice Melgert · Answer

Change the Job Relationship join to a right join.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 81 - C_THR92_2405 discussion

Suggested answer: D

0 comments