Methods of cleaning data before it loaded in data warehouse
Answers
Answered by
0
We have a fixed number of operations to be applied on the operational databases and we have well-defined techniques such as use normalized data, keep table small, etc. These techniques are suitable for delivering a solution. But in case of decision-support systems, we do not know what query and operation needs to be executed in future. Therefore techniques applied on operational databases are not suitable for data warehouses.
In this chapter, we will discuss how to build data warehousing solutions on top open-system technologies like Unix and relational databases.
Process Flow in Data Warehouse
There are four major processes that contribute to a data warehouse −
Extract and load the data.
Cleaning and transforming the data.
Backup and archive the data.
Managing queries and directing them to the appropriate data sources
In this chapter, we will discuss how to build data warehousing solutions on top open-system technologies like Unix and relational databases.
Process Flow in Data Warehouse
There are four major processes that contribute to a data warehouse −
Extract and load the data.
Cleaning and transforming the data.
Backup and archive the data.
Managing queries and directing them to the appropriate data sources
Similar questions