In addition, no one on the team had any prior data warehouse implementation experience. The Gartner consultant provided high-level guidance, but was not directly involved. Some portion of the staff must have existing operational system knowledge. However, it must be recognized that knowledgeable resources are not always available and in some cases, may not exist. Consultants with hands-on experience in data warehousing should be used to help implement additional data warehousing projects.
Data warehousing is too complicated to learn from literature and theoretical consultants.
Resource requirements for a data warehouse are ongoing. They do not end with implementation. As changes occur in the operational system from which the data warehouse was derived or new data elements need to be captured, modifications will be required. Some difficulties occurred during the pilot due to the way the current State operating environment is defined. Limits were reached on the amount of sortwork space allocated for flat files and DB2.