Hi,
This has to be done in oracle only.
This is one of the questions asked in WIPRO interview for Datawarehousing positions.
Suresh.H.T