Results 1 to 3 of 3

Thread: datamarts

  1. #1
    Join Date
    May 2002

    Unanswered: datamarts

    what are the advantages of building a datamart in sql server as opposed to DB2 or vice versa?? any thoughts would be appreciated.

  2. #2
    Join Date
    Sep 2003
    the biggest one is analysis services are free in sql.

  3. #3
    Join Date
    Jan 2003
    Provided Answers: 11
    This would go back to the same arguments for any software purchase. My criteria is usually what do you have the most experience in at your shop. Database software at this level is getting pretty generic. SQL Server, DB2, and Oracle do mostly the same things, and generally have their shares of rabid followers. Look around your shop, and if you have mostly SQL experts, then go with SQL. If you have more DB2 expertise, go with DB2. The cost of ownership will be less, if you do not have to send people out for a lot of training, and spend needless hours chasing simple problems that experienced people would laugh at.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts