Explain what are the steps to build the data warehouse?
- 1 Answers
- 1025 Views
- I also Faced
- E-Mail Answers
Answer / Meenu Kumari
Building a data warehouse involves several key steps. The process typically includes:n
1. Requirement Analysis: Identify business needs, data sources, and user requirements.
2. Conceptual Design: Develop high-level concepts and entities that capture the organization's data and relationships.
3. Logical Design: Define detailed schemas and tables based on the conceptual design.
4. Physical Design: Determine database structures, storage strategies, and access methods for efficient data processing.
5. Implementation: Build the actual data warehouse using ETL tools and databases.
6. Testing and Optimization: Validate the data warehouse and optimize performance as needed.
7. Deployment and Maintenance: Make the data warehouse available to users, monitor its usage, and perform regular maintenance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What according to you might be the future of data warehousing?
capital of tamilnadu
What is a full backup?
What are the different problems that ?Data mining? can solve?
how to calculate sum(sal) with out using aggregator satge
What is the difference between a primary and secondary actor in use case modeling?
What are Non-additive facts?
What is dimension modeling?
How to know the time taken for particular report execution?
Explain difference between data ware house & data mart?
What should I have in mind when building olap solution from scratch?
What is incremintal loading?
Teradata 
