Describe the most common strategy for creating a data warehouse

What will be an ideal response?

The common strategy for drawing information from multiple sources is abbreviated as ETL, short for extract, transform, and load. The first step is to extract data from its home database, and then transform and cleanse it so that it adheres to common data definitions. After this step has been completed, data from external resources that will enrich the value of the data warehouse for intelligence gathering and marketing is combined with the data extracted from internal sources. The data is loaded into the data warehouse, typically another database. At frequent intervals, the load process repeats to keep it up to date.