help please

Sample  Files  from  the  Two  Systems   The following are sample files from the two systems that would supply the data for the data warehouse: Mechanical Parts Division Sales System Database: MPD Table: Sales

Prod_ No

Product_ Description

Cost_per_Unit Units_Sold Sales_Region Customer_ID

60231 4” Steel bearing 5.28 900,245 N.E. Anderson

85773 SS assembly unit

12.45 992,111 M.W Kelly Industries

Corporate Sales System Database: CSS Table: Sales

Product_ID Product_ Description Unit_Cost Units_Sold Sales_ Territory

Division

60231 Bearing, 4” 5.28 900,245 Northeast Parts

85773 SS assembly unit 12.45 992,111 Midwest Parts