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?

Question

Edgar Zapico · Accepted Answer

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.

Edgar Zapico · Answer

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.

Edgar Zapico · Answer

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.

Edgar Zapico · Answer

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.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 32 - C_HAMOD_2404 discussion

Suggested answer: C

0 comments