To give you more clarity about my requirement,
Mine is a SQLSERVER 2005 source database,
I want to build an ODS out of it to show the Present data,
And a staging database to hold the historical data.
If you would provide me a most suitable method
Sample example or
Sample process Or
Sample Methodology or
Sample project that would be greatful.