What are the stages that are required in data warehousing?
- 1 Answers
- 1048 Views
- I also Faced
- E-Mail Answers
Answer / Awadhesh Singh Yadav
The stages required in data warehousing are:
1. Requirements Analysis: Define business requirements and data sources for the data warehouse.
2. Data Extraction: Extract raw data from various operational systems and data stores.
3. Data Cleaning: Clean and transform data to ensure it is ready for loading into the data warehouse.
4. Data Integration: Combine data from multiple sources, applying business rules and resolving conflicts as necessary.
5. Data Storage: Load cleaned and transformed data into the data warehouse's storage system.
6. Metadata Management: Manage metadata describing the data warehouse structure, data quality, and relationships between entities.
7. Data Security: Implement security measures to protect the data warehouse from unauthorized access.
8. Data Access and Delivery: Provide users with tools for querying and visualizing the data warehouse.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are vaious etl tools in the market?
Explain Process flow in data warehouse??
What is operational data source (ODS)?
How many ways we test the universe & Report?
what is the diffrence between psa and idoc
What are steps we have to follow in designing the userfriendly universe?
what is the use of surrogate key in businessobjects
What is confirmed dimension?
Best Data Ware housing training institute in delhi
What are the different methods of loading dimension tables?
What is MODEL is Data mining world?
Teradata 
