Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 09, 2010, 06:04:08 am


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Basic question about DW  (Read 519 times)
werder85
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« on: April 01, 2010, 07:23:33 pm »

'm really new to DW...I know classical databases pretty good (for operational applications).
I've read a bit about the concepts of DW.

I don't really know now, which software package I should use.
What do you suggest as to be the best or easiest solution: mysql, ms sql server, etc.

Please help me out, as I don't want to start this wrong and lose a lot of time for nothing.
Thanks a lot!
Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 114


Forum Don


View Profile WWW
« Reply #1 on: April 01, 2010, 09:55:06 pm »

A Data warehouse comprises several components (DB, ETL, OLAP, Reporting), each one of which can be implemented using one of various software tools available.

In fact, this forum itself is broken down into different sections based on the components and software packages.

DB - Oracle, MS SQL server, DB2, Teradata etc.
ETL - Informatica, MS SSIS, Ab Initio, Oracle Warehouse Builder, Data stage etc.
Reporting - Business Objects, Cognos, MS SSRS, Hyperion, Brio etc.

Most vendors specialize in one field - Oracle and MS are probably the only two which provide you with more than one component.
And MS SQL Server is probably the only one which includes all of them in one license - DB, OLAP, ETL and Reporting.
Oracle too, has products for each component of a data warehouse, although I'm not sure of their licensing policy.

That said, if you've got the basics "down", you can find your way around any software package with relative ease.
In my last job, I've worked on Unix/Oracle/Informatica. In my current job I work with MS SQL server. Wink
Logged

You don't get it.  I built this place. Down here, I make the rules. Down here, I make the threats. Down here, I'm God.
anu4u09
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 5



View Profile
« Reply #2 on: June 17, 2010, 11:02:51 pm »

can any 1 plz update DWh interview questions this my id <removed> Smiley

Quote from: Sipra
E-mail removed. Please do not post your email openly - it invites spam.
Members who wish to contact anu4u09 personally, please use
private messaging instead.
« Last Edit: July 25, 2010, 01:56:05 am by Sipra » Logged

Pages: [1]   Go Up
  Print  
 
Jump to:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM