Question 5:
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.