Basic Datawarehouse Table Structure Design for Dialer database RRS feed

  • Question

  • Hello Friends

    I need your valuable help.

    I have  an transactional database not in SQL SERVER  but we synch data in SQL SERVER on daily basis using SSIS.

    Now i need to create a database in for my cubes in SQL so i can access these directly in my cube i'm not sure that we called these as an staging table ..?so what should i include in these tables what not ?? i'm sure we'll not include all the tables in data warehouse database.

    so  kindly suggest me some links where i can design my database and tables for SSAS cubes.

    please provide me some Links,Technical Document anything what can you provide.

    We are working with CallerCenter Database that is Dialer Database.



    Friday, January 11, 2013 4:53 AM