read the "datawarehouse guide" from the oracle documentation