What must you do to ensure that the Mapping that gets e…

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.)

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.)

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.

Explanation:
(http://odiexperts.com/changed-data-capture-cdc/)



Leave a Reply 0

Your email address will not be published. Required fields are marked *