I need to build a Data Warehouse for an existing SQL Server database. I already have the design of the star schema dimension and fact tables. My question is:
Is there a tool in SQL Server 2008 Enterprise to help me with translating my data from the transactional database into the new data warehouse database? I am looking for a tool that helps me cleanup my data and populate the warehouse tables. I have done this before in an academic environment using Oracle databases. In this case I had to do everything "manually" with SQL.
You must check IMPORT and EXPORT functionality of MS - SQL SERVER, watch this video: http://www.youtube.com/watch?v=eDfhTPU7P-M