Explain what are the steps to build the data warehouse?
- 1 Answers
- 1027 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
