Union Bank interview question

Data warehousing question about dimensional modelling