The following hierarchy has been created:
Before executing the dimension build, the developer wants to ensure that duplicate rows are excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?
A. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.
B. Specify that duplicate rows are to be rejected on the Audit tab of the dimension build’s properties.
C. Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.
D. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy’s properties.
|
Download Printable PDF. VALID exam to help you PASS. |
 |