Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

SAP Exam C_HANAIMP_18 Topic 1 Question 34 Discussion

Actual exam question for SAP's C_HANAIMP_18 exam
Question #: 34
Topic #: 1
[All C_HANAIMP_18 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Kristeen at Mar 19, 2024, 01:55 AM

Limited Time Offer

25%

Off

Get Premium C_HANAIMP_18 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Tawna
1 years ago
I think option C could also work. Using an aggregation node in a calculation view might provide some performance benefits.
upvoted 0 times
...
Eugene
1 years ago
I tend to agree with Elfrieda. Option A seems to provide a direct approach for connecting dimensions to the fact table.
upvoted 0 times
...
Elfrieda
1 years ago
But wouldn't using a star join node directly to connect the dimensions to the fact table be more efficient as in option A?
upvoted 0 times
...
Mattie
1 years ago
I disagree, I believe option B is the best approach. We should combine the transaction tables using a join node in a calculation view with star join.
upvoted 0 times
...
Elfrieda
1 years ago
I think the correct approach is option A. We should use a star join node in a calculation view of type cube with star join.
upvoted 0 times
...
Almeta
1 years ago
I see your point, but I still think using a join node as in option B is the most efficient way to connect the dimensions to the fact table.
upvoted 0 times
...
Daren
1 years ago
Haha, this question is a real star-studded affair! I'm going with A) - can't go wrong with the classic star join.
upvoted 0 times
Jamika
1 years ago
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.
upvoted 0 times
...
Francene
1 years ago
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.
upvoted 0 times
...
Hana
1 years ago
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.
upvoted 0 times
...
...
Micheline
1 years ago
I agree with using an aggregation node in a calculation view of type cube with star join sounds like a good approach.
upvoted 0 times
...
Natalie
1 years ago
But wouldn't it be better to use an aggregation node instead, like in option C?
upvoted 0 times
...
Karon
1 years ago
Ah, the good old star schema! D) seems like it could work, but I'm leaning towards A) for the clean star join setup.
upvoted 0 times
Eun
1 years ago
Let's go with A) then, for a clear star join structure.
upvoted 0 times
...
Brock
1 years ago
I agree, D) could work too but A) seems more straightforward.
upvoted 0 times
...
Cherilyn
1 years ago
I think A) is the way to go for a clean star join setup.
upvoted 0 times
...
...
Barney
1 years ago
C) Aggregation node for the transaction tables? Interesting, but I'm not convinced that's the correct approach.
upvoted 0 times
Elke
1 years ago
B) 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.
upvoted 0 times
...
Bette
1 years ago
A) 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.
upvoted 0 times
...
Steffanie
1 years ago
B) I think using a join node in a calculation view of type cube with star join might be a better approach.
upvoted 0 times
...
Micheline
1 years ago
A) 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.
upvoted 0 times
...
Danica
1 years ago
B) 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.
upvoted 0 times
...
Virgilio
1 years ago
A) 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.
upvoted 0 times
...
...
Almeta
1 years ago
I believe option B is the right choice, combining the transaction tables using a join node in a calculation view of type cube with star join.
upvoted 0 times
...
Tequila
1 years ago
B) Hmm, I'm not sure a regular join node would be the best option here. Shouldn't we be using a star join for the dimensions as well?
upvoted 0 times
...
Billye
1 years ago
A) Looks like the right approach to me. Star join is the way to go for a star schema.
upvoted 0 times
Penney
1 years ago
D) Combining the transaction tables using a star join node in a calculation view of type cube with star join seems like a good approach.
upvoted 0 times
...
Alex
1 years ago
B) You're right, a star join node is more suitable for this scenario.
upvoted 0 times
...
Kanisha
1 years ago
A) Aggregation node might not be the best choice for creating a star schema.
upvoted 0 times
...
Devora
1 years ago
C) I would go with combining the transaction tables using an aggregation node in a calculation view of type cube with star join.
upvoted 0 times
...
Alyssa
1 years ago
A) I agree, using a star join node for a star schema is the best practice.
upvoted 0 times
...
Amie
1 years ago
B) I think using a join node in a calculation view of type cube with star join is the correct approach.
upvoted 0 times
...
Cheryl
1 years ago
A) 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.
upvoted 0 times
...
...
Natalie
1 years ago
I think the correct approach is to use a star join node in a calculation view of type cube with star join to combine the transaction tables.
upvoted 0 times
...

Save Cancel