Interview Question in Data Warehousing


 

Interview Question :: Question about which database to use


Hello and goo day! Help would be much appreciated!

A scenario from one of my data warehousing classes...

A client is in need of a database for his sales web app

and the client is stuck between choosing Microsoft SQL Server or MySQL

which database do you think should the client choose? and why should he choose that database...

Thanks a lot people!!!
Answers to "Question about which database to use"
RE: Question about which database to use?

You have said nothing about what the requirements are. Please provide more information about the website backend and integration capabilities, this would be good.



If you are doing data warehousing, then you can choose either db, but the more prevalent one in the web world is probably MySQL since it is open source. A good tool to use for the ETL could be EMANIO's Unite! product http://www.emanio.com/DataIntegration/un...
 
Vote for this answer ::  
Update Alert Setting