Answer 1

extract, transform and load: You extract similar data from multiple sources. Then you transform it into a certain scheme and finally load it into a destination database.

Example: You want to compare football clubs from multiple countries and leagues.
1. download data from Spain, UK and Germany
2. transform into a scheme that applies to all leagues
3. load the data into a single DB