Union Bank Interview Question

Data warehousing question about dimensional modelling