Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?
A. Accept unmatched member identifiers in the measure element properties.
B. Modify the SQL for the reference structure to exclude the missing product codes.
C. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
D. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
|
Download Printable PDF. VALID exam to help you PASS. |
 |