C_HAMOD_2404 Exam Dumps | You want to create a star schema using a calculation view. The measures are based on columns from two

<< Prev Question Next Question >>

Question 12/36

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes.What is the correct approach?

A. Combine the transaction tables using a join node in a CUBE calculation view.
* Use a star join node to join the DIMENSIONS to the resulting fact table.

B. Combine the transaction tables using a join node in a CUBE calculation view.
* Combine the DIMENSIONS using another join node.
* Use a star join node to combine both resulting fact and dimension tables.

C. Combine the transaction tables using an aggregation node in a CUBE calculation view.
* Use a star join node to join the DIMENSIONS to the resulting fact table.

D. Combine the transaction tables using a star join node in a CUBE calculation view.
* Use a join node to join the DIMENSIONS to the resulting fact table.

Question 12/36

LEAVE A REPLY

Download PDF File