SQL Server Performance

Do I need to Create Customized Database to design?

Discussion in 'SQL Server 2005 Analysis Services' started by bhushan_juare, Jul 31, 2011.

  1. bhushan_juare New Member

    Hi Guys,

    I am refering AdventureWorks2008 Database for Cubes design and I have noticed database is organised as per Cubes requirnment. I want to know,

    1) Is it essential that cube database is customised?

    2) Can I use any database to design Cube?

    3) Do I need to design fact tables, dim tables looking towards Cube?

    4) If so, how to create heirarchy between fact & dimension tables physically in database?
    bhushan_juare, Jul 31, 2011
    #1

  2. satya Moderator

    1) yes
    2) Yes
    3) Not necessarily
    4) Better to download updated books online for SQL 2005 and read on
    satya, Aug 3, 2011
    #2

Share This Page