Computer Science, asked by binysagariya, 6 months ago

Suppose you are an analyst at a bank, and you have a data file with the following six variables: Withdrawal amount, Account balance after withdrawal Transaction charge amount, Customer ID, ATM ID, Date of withdrawal.
Based on a star schema, how many dimension variables would you need in order to determine the number of withdrawals made in Puducherry by a customer named Rohit Sharma?

Answers

Answered by ashhadeh
23

Answer:

At least 2

Explanation:

You will need  a customer name dimension, which connects with the customer id, and an ATM location, which connects to the ATM ID.

Answered by abdulraziq1534
0

Concept Introduction:-

A sentence which has a subject, verb, object, and modifiers.

Explanation:-

A question has been provided to us

We need to find the solution to the question

There are two dimensions should be observed while determining the number of withdrawals made in Puducherry by a customer named Rohit Sharma. You would require a customer name dimension, which connects with the customer id, and an ATM location, which connects to the ATM ID. One would need an ATM location, which corresponds to the ATM ID, and a customer name dimension, which ties to the customer id.

Final Answer:-

The correct answer is two dimensions.

#SPJ3

Similar questions