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.)
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.
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1614)