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”.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.