This content has been marked as final. Show 2 replies
Please checkout this link: http://st-curriculum.oracle.com/tutorial/ORDMTutorial/player.htm
and this page http://www.oracle.com/technetwork/database/options/retail-data-model/index-082666.html and the documentation set http://download.oracle.com/docs/cd/E14439_01/welcome.html that it points to.
Most of your questions can be answered by skimming through these pages and manuals, and I would say most of your questions will get quite a positive answer.
One of the main characteristics of its general design is that there is no default source system that it was built for, so it is quite generic (ARTS data model based) but an implementation project requires to fill in the ETL to the first layer. For some sources (e.g. Oracle Retail RMS) this has been done several times by some partners. But this should be no set back, as almost any DWH project will need to deal with the source extraction layer.
Erwin/SA is not used, at least not in the general availability release.