Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vgarzon
Starting Member
11 Posts |
 Posted - 2011-08-02 : 18:44:42
|
| Hi,I have the whole SQL server 2008 suite, and I'm currently extracting many reports using views.The thing got more complex than expected and now I have bought a new server in which I want to build a Data warehouse and copy my transactional DB to a warehouse on the new server for converting it into a reporting server.The thing is that I already have the views that extract my reports and now I want to build a fact table for each view. The issue is that the views use many tables, subqueries and functions, joins and all kinds of stuff to be able to generate them, so I don't know how to start.I would like to know how to use several data OLE DB data sources, and how to build the many joins of the view. I know how to do the lookups from one transactional table to "fill" or "update" one dimensional fact table.Any suggestions, reading, videos or any kind of help that I should use?Thanks in advance,Vic |
|
|
|
|
|
From Views to Cubes