What is the difference between database and data warehouse - ETL?
ETL (extract, transform, and load) Testing Interview Questions
(Continued from previous question...)
23. What is the difference between database and data warehouse - ETL?
A database is a collection of related data.
A data warehouse is also a collection of information as well as a supporting system.
In Data base we can maintain only current data which was not more than 3 years But in datawarehouse we can maintain history data it means from the starting day of enterprise DDL commands it means ( Insert ,update,delete)we can do in Database In datawarehouse once data loaded in Datawarehouse we can do any DDL operatations.
Database is used for insert, update and delete operation where as datawarehouse is used for select to analyse the data.
A database is a collection of related data. Where as Data Warehouse stores historical data, the business users take their decisions based on historical data only.
(Continued on next question...)
Other Interview Questions