Weird Scenario....Please Help!!
We have a deadline and we may not be able to test the newly built datawarehouse fully in test and prod environment.So,we have decided upon an interim plan that would take the
“development” OWB scripts and processes, and manually manage the deployment and execution for the first several weeks or month.
This may sound strange, but can the deployment scripts/processes for maintaining the data warehouse tables (e.g. Dimension, Fact, Staging) be deployed and then executed manually, completely outside the OWB environment? This would include the daily incremental processes to maintain the Fact tables and the insert/update processes necessary to maintain the Dimension tables and the process flows and schedules?
Or is there any other quicker way to get around this problem?