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
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.
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