You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains two tables named Orders and OrderDetails. There is also a data warehouse containing…

You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains two tables named Orders and OrderDetails. There is also a data warehouse containing a table named factSales. The factSales table has a de-normalized structure and contains columns from Orders and OrderDetails. You plan to design a solution that will extract all data modifications from Orders and OrderDetails and load them into factSales. You have the following requirements:

• The load operation is incremental and runs daily.
• The schema of the tables cannot be modified.
• The history of each modification is maintained for one month.

You need to implement the solution by using the least amount of coding and administrative effort. What should you do?