How easy is it to create the warehouse schema with OWB?
OWB gives the user a wizard-driven design environment to create the dimensional warehouse schema. Wizards guide the user through the creation of dimensions with multiple levels and hierarchies, the creation of keys on these levels, and the linking of these dimensions to the fact tables. OWB provides wizards for all database objects supported in OWB.