Does Warehouse Builder support incremental design and can it add changes to an already loaded warehouse?
Warehouse Builder seamlessly utilizes the Change Management functionality of Oracle Enterprise Manager to propagate changes in the metadata to the actual warehouse. Warehouse Builder can add columns, keys, tables, dimensions and facts without causing any disruption to the present warehouse. Removing of elements is supported as well. The Change Management component of Oracle Enterprise Manager is shipped and installed as part of Warehouse Builder.