SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 02:25 PM
| ||||
| ||||
 OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005 Hello, Can I import an OLTP (Reltional DB) as a Data Source into SQL Server Analysis Services 2005 and then use the Cube Wizard and the new Data Source View feature to create the OLAP model ? Or do I have to first design an OLAP Data Warehouse with a Star Schema and then import this DW as a Data Source into my Analysis Services Project. With SQL Server 2000 , OLAP would be the way to go..but with SQL Server 2005 , it seems as though the wizard and data source view features do half the work for you. I have an OLTP DB and am not sure which route I should take ! Any suggestions / input would be much appreciated. Thanks in Advance... Regards Russzee      |
|
03-01-2008, 02:25 PM
| ||||
| ||||
| Re: OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005 Here's the followup answer to my own post... Just what I thought...It's the new UDM all the way in SQL Server 2005 !!! "SQL Server 2005 Analysis Services can create UDM cubes without the intermediate step of building a star schema data warehouse. The UDM enables organizations to build reporting applications directly against a production system and doesn't require an intermediate data warehouse as in the past. This is because the UDM doesn't require the data to be in a star or snowflake schema, but can connect to any data source whose data is stored in a third normal form. " Source : http://www.microsoft.com/technet/pro.../solvngbp.mspx |
Linear Mode
