8. Select the correct statements about ODS settings.
a. Performance of the ODS activation improves when the BEx reporting flag is switched to off.
b. Overwriting a data record is not allowed if the 'unique' data record flag is set.
c. Data targets are updated from the ODS regardless of the ODS activation status.
d. All of the above.
ANSWERS: A, B
If the BEx Reporting flag is switched off than the SID won't have to be taken when activating the ODS. This improves performance. If the 'unique data records' flag is set, it is not possible to load records to the ODS for which the key combination already exists. Data targets can be updated only after the ODS activation takes place successfully.
Go back to the BI/BW quiz answer sheet
