What are different deliverables according to phases?
- 1 Answers
- 3505 Views
- I also Faced
- E-Mail Answers
Answer Posted / Akash Avasthi
In a data warehouse project, deliverables can vary across phases. Here's a simplified list for some common phases:
1. Business Requirements Document (BRD): A document outlining the business needs and objectives of the project.
2. Data Dictionary: A comprehensive glossary containing all the terms and definitions used in the data warehouse.
3. Conceptual Data Model: A high-level representation of the data warehouse schema, including tables and relationships between them.
4. Logical Data Model: A detailed description of the proposed data structures, entities, attributes, and relationships.
5. Physical Data Model: A specification of how the data will be stored and managed in the database system.
6. ETL (Extract, Transform, Load) Process Design: The procedures for extracting raw data from various sources, transforming it into a usable format, and loading it into the data warehouse.
7. Data Warehouse Database Schema: The final structure of the data warehouse database, including tables, indexes, and other database objects.
8. User Documentation: Detailed instructions on how to use the data warehouse, including query examples, security guidelines, and user interface descriptions.
9. Training Materials: Educational resources for end-users and administrators on how to effectively utilize the data warehouse.n10. Performance Testing: Verification of the data warehouse's ability to handle expected loads and queries efficiently.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain how to generate iqd file from framework manager?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
