We need to create a parent child hierarchy for city wise branches
In our DB we have only one table - the same we need to consider as Dimension & Fact.
Attributes as follows:
customername, customernumber, accountnumber,city, branch, financialyear,financialquarter
We do not have primary key on above structure.
But we can get unique composite key by combining: Account Number, city & branch attributes.
- MG Road
- Silk Board