Oracle interview question

Sql python data warehouse dimensional modelling