LYCOS RETRIEVER 
Data Warehouse
built 233 days ago
The Data Warehouse is implemented (populated) one subject area at a time, driven by specific business questions to be answered by each implementation cycle. The first and subsequent implementation cycles of the Data Warehouse are determined during the BQA stage. At this point in the Process the first (or next if not first) subject area implementation project is planned. The business requirements discovered in BQA and, to a lesser extent, the technical requirements of the Architecture Design stage are now refined through user interviews and focus sessions to the subject area level. The results are further analyzed to yield the detail needed to design and implement a single population project, whether initial or follow-on. The Data Warehouse project team is expanded to include the members needed to construct and deploy the Warehouse, and a detailed work plan for the design and implementation of the iteration project is developed and presented to the customer organization for approval.
Source:
Ben Waldshan, a founder of Data Warehouse, and now an Executive Vice President with TRANZACT, sees his company's clients benefiting from the TRANZACT transaction. "By joining forces with TRANZACT, we enhance our robust data solutions by offering a range of strategic and marketing execution capabilities that our clients, especially the large, national ones, want and need." Ben continued, "By moving up the value chain with our clients, we become the leader in a set of highly demanded, fully integrated solutions to the large and diverse credit and mortgage issuing marketplace."
Source:
The Data Warehouse is built from the transactional systems. Data is identified for inclusion, checked for redundancy, and restructured if necessary (using a combination of fields to create a new field). Once the data is identified, it is put into the Data Warehouse. The data is periodically refreshed, determined by the static/nonstatic nature of the data, need, etc. Some Data Marts are refreshed nightly, others not as frequently. This data is for queries only, any changes to data must be made in the transactional system.
Source:
The Architecture is the logical and physical foundation on which the Data Warehouse will be built. The Architecture Review and Design stage, as the name implies, is both a requirements analysis and a gap analysis activity. It is important to assess what pieces of the architecture already exist in the organization (and in what form) and to assess what pieces are missing which are needed to build the complete Data Warehouse architecture.
Source:
Because a uniqueidentifier data type cannot be sorted, the GUID cannot be used in a GROUP BY statement, nor can the occurrences of the uniqueidentifier GUID be distinctly counted—both GROUP BY and COUNT DISTINCT operations are very common in data warehouses. The uniqueidentifier GUID cannot be used as a measure in an Analysis Services cube.
Source:
Now that you have rolled your data warehouse into production, how do you know if you've done a good job? Finishing on time and on budget is good, but that alone doesn't guarantee the project's success.
Source:
MORE ABOUT
Data Warehouse