Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 2

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.
What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

Answer options

• A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change the JRN_SUBSCRIBER column in the corresponding J$ table to keep the changed data present for the second Mapping.
• B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
• C. Duplicate the source data store for each Mapping.
• D. Create two distinct subscribers for each Mapping.

Correct answer: A

Explanation

The correct answer, A, ensures that the changed data remains available for the second Mapping by managing the journal data appropriately. Options B and C introduce unnecessary complexity with additional mappings or data stores, while D does not address the issue of data consumption between the two mappings.