Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 20

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

Answer options

• A. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.
• B. The Knowledge Module must be customized only for aggregation functions.
• C. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.
• D. The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Correct answer: D

Explanation

Option D is correct because while the Knowledge Module itself does not require customization, utilizing a variable in the aggregate expression is essential to ensure the correct sum is calculated. Option A is incorrect as it suggests an unnecessary level of customization. Option B limits customization to only aggregation functions, which is not accurate. Option C is misleading because while ODI does generate code, using a variable is still necessary for proper aggregation.