How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

• A. Use the same schema as the Data Schema.
• B. UseTEMP.
• C. Use SYSTEM.
• D. Use a dedicated schema such asODI_STAGING.

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 theinitialload and one for the incremental updates.
• B. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.
• C. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.
• D. 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.

You design a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this? (Choose the best answer.)

• A. Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
• B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes.
• C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes.
• D. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.

You need to implement security mechanisms that allow only user "A" to view all the Mappings contained in a specific project named "P1." How must you proceed? (Choose the best answer.)

• A. Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.
• B. Go to Security, assign the DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Mapping objects.
• C. Go to Security, assign the NG DESIGNER profile to user "A." Next, drag project "P1" to user "A" and finally set View privileges to Active for the Project, Folder, and Mapping objects.
• D. Go to Security, assign the NG DESIGNER profile to user "" Next, drag project "P1" to user "A" and finally setView privilegesto Active for the Mapping objects.