ETL, combine data from multiple database

There are 3 databases: SuperStoreDB, DemoDB, and week7lab.

We need to collect Products data from all 3 databases into your database for analysis.

Data: Product Name, ProductFamily, Unit Price, Source Database

1. Examine SuperStoreDB.fi_Product, DemoDB.Product , week7lab.products to find columns with necessary information

2. Select the data from each database and create one common view.

• a. query each database table getting correct information , add database name as an extra column ( HINT: select col1, col2, “db_name” as source from my_table )
• b. combine all 3 query with UNION ALL in a single query
• c. create a view Week11_ETL_vi from the query in step “b”.