FIT3002 Lecture Notes - Lecture 3: Clipsham, Online Transaction Processing, Table Table
Document Summary
Critical success factors: executive sponsor/funding, effective team, mostly- interpret user requirements. Is it feasible: need strong business manager sponsorship in the first instance, data availability reliable, clean, ease of development and deployment, resource availability technology, infrastructure, experience. Involve representatives of various departments: dw users are not professional programmers, dw users will not share a common understanding of how data is used, a very large number of users but . Users often don"t know what questions to ask until they have worked with the wh for a while. Determine the reports that dw is supposed to support. Populate the staging area with the data extracted from transactional sources. Build extraction transformation and loading (etl) routines to populate the dimensional database regularly. Build reports and analytical views maintain the warehouse by adding/changing supported features and reports. Erdsvstar schema: aim of erd to remove redundancy, beneficial to transaction processing, based on relationships, normalized.