Duplicate
Export
Register
Lifecycle Track
1 PDF
1 Flashcard Deck
1 / 1
100%
Create Flashcards
View
Lecture 3_ Kimball Lifecycle and Dimensional Modelling_DWM.pptx_removed.pdf Flashcards
Study
What is the aim of the SDLC?
The SDLC aims to produce a high-quality software that meets or exceeds customer expectations, reaches completion within time and cost estimates.
What is the purpose of the technical architecture in the SDLC?
The technical architecture is the blueprint for the DWBI environments, technical services, and infrastructure.
What are the steps involved in establishing the architecture?
1. Establish Architecture Task Force 2. Collect Architecture-related Requirements 3. Document Architecture Requirements 4. Create the Architecture Model 5. Determine Architecture Implementation Phases 6. Design and Specify Subsystems 7. Create the Architecture Plan 8. Finalize and Review Technical Architecture.
What is the architecture plan similar to?
The architecture plan is similar to a shopping list for selecting products that fit into the plans framework.
What are the steps to product selection and installation in the SDLC?
1. Understand Corporate Purchasing Process 2. Develop Product Evaluation Matrix 3. Conduct Market Research 4. Evaluate a Shortlist of Options 5. If Necessary, Conduct a Prototype 6. Select Product 7. Install Trial and Negotiate.
What does the Physical Design phase involve in the Kimball Lifecycle?
The Physical Design phase involves translating dimensional models into a physical database and includes the following activities: 1. Develop Naming and Database Standards 2. Develop Physical Database Model 3. Develop Initial Index Plan 4. Design Aggregations including OLAP Database 5. Finalize Physical Storage Details.
What is the focus during the BI Application Specification phase?
During the BI Application Specification phase, it is helpful to establish standards such as common pulldown menus and consistent output look and feel.
What should be revisited during BI Application Development?
The BI application template specifications should be revisited to account for changes to the model since the specifications were completed.
What is involved in the Deployment phase of the BI Application Track?
Deployment refers to the process of making the application work on a target device, whether it be a test server, production environment, or a user's computer or mobile device.
What are the key aspects of Maintenance and Growth after deployment?
a. User support is crucial following deployment. b. A continuing education program for the DW BI system must be provided. c. Technical support should treat the DWBI system as a production environment with service level agreements. d. The DWBI program continues beyond the implementation of a single phase.
What are some pitfalls to avoid in the Kimball Lifecycle?
The document does not specify the pitfalls to avoid in the Kimball Lifecycle.
Scholarly Assistant's Insights
Explore the key concepts of the Kimball Lifecycle and Dimensional Modelling in data warehousing.
Data Warehousing
Dimensional Modeling
Software Development
System Development Life Cycle
Bi Application
+5 more
Ask Scholarly Assistant
Similar Pages
Login to Leave a Comment
Give your feedback, or leave a comment on a page to share your thoughts with the community.
Login