What are different deliverables according to phases?
- 1 Answers
- 3503 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the difference between ods and oltp?
What are the advantages of raid 1, 1/0, and
What is the use of tabular model, tabular sql, tabular reference in real time application?
what is the difference between DSS and ODS ?
OLAP architecture?
Why facts table is useful in representing the data?
What is the difference between olap and datawarehosue?
What are the steps to build the datawarehouse?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain how are the dimension tables designed?
Define Data Warehousing?
what is data validation strategies for data mart validation after loading process
Teradata 
