What is the correct approach?

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 star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.
B . Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
C . Combine the transaction tables using a join node in a calculation view of type CUBE with star join. Use a star join node to join the DIMENSIONS to the fact table.
D . Combine the transaction tables using a star join node in a calculation view of type CUBE with star join. Use the same star join node to connect the DIMENSIONS to the fact table.

Answer: C

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments