Data Warehousing Community Forum
February 09, 2012, 01:40:41 pm

Pages: [1]   Go Down
  Print  
Author Topic: DW/BI in Oracle or Sql Server 2008?  (Read 885 times)
thierryvdb
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« on: July 29, 2010, 12:33:58 am »

Hi all,

I hope someone can help me with a couple of questions related to Oracle/MSSQL DW/BI Environments.

I'm new to DW/BI but not to Databases ( Actually an Oracle DBA ) and I'm hoping to learn the most of it, but I'm not sure where to begin.

Which DW/BI technology is best?Oracle or MSSQL?
Where should I start?
Which documentation/Tutorial/Book/Site/Video  would you recommend?

I'll be in Vacation for 30 day's and would like to maximize my studies in DW/BI (8 Hours a day)

Thanks in advance.


Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: July 29, 2010, 10:51:13 am »

Which DW/BI technology is best?Oracle or MSSQL?
Where should I start?
Which documentation/Tutorial/Book/Site/Video  would you recommend?
The jury is still out on the absolute "best" technology ... but Oracle+Informatica has a bigger market share than MSSQL - that's probably a good indicator.  Wink

A good place to start would be to master the basic concepts of DW. Do that, and it's more than half the job already done.

Personal suggestion - MSSQL BI products come with a very good sample DW implementation called "Adventure Works" - even if you're not focusing on MSSQL, that is a good place to learn the abstract DW basic concepts and their practical implementations.

p.s. - Oracle might have something similar to Adventure Works, but I'm not really an Oracle person.
Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: