Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 22

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the best answer.)

Answer options

• A. Create a single Mapping with two Physical Designs: one for the initial load and one for the incremental updates.
• B. Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.
• C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.
• D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

Correct answer: D

Explanation

The correct answer is D because it allows for a single Mapping to efficiently handle both scenarios by using variables to determine the type of load. Options A and C complicate the design by creating unnecessary duplication, while option B lacks the flexibility to handle both initial and incremental loads effectively without modification.