In my current setup, I've have a SQL Server 2005 acting as a datawarehouse. Informatica is the ETL. Oracle ESSBASE is the dashboard and analyatical tools.
What will be the benefits and costs savings if the ETL is changed to Integration Services and the ESSBASE is replaced by Reporting Services and Analysis Services ? Are the inherent SQL Services on par with those mentioned 3rd party tools ? Or much better
? Say in SQL Server 2008 ?
Like your opinions please.
View Complete Post