dbTalk Databases Forums  

Relational to datawarehouse

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Relational to datawarehouse in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Luis Esteban Valencia
 
Posts: n/a

Default Relational to datawarehouse - 07-29-2005 , 10:46 AM






Can sombeody point me in the right direction. How can I convert a relational
database to a datawarehouse?

Thanks



Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Relational to datawarehouse - 07-30-2005 , 07:11 AM






Personally I would start with Mr Kimball's books.

The Data Warehouse Lifecycle Toolkit
The Data Warehouse ETL toolkit.

I would have a look for articles on star and snowflake schemas.

What makes up your warehouse will depend to a large degree , certainly for
the fact table, on what you are trying to model.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Luis Esteban Valencia" <levalencia (AT) avansoft (DOT) com> wrote

Quote:
Can sombeody point me in the right direction. How can I convert a
relational database to a datawarehouse?

Thanks




Reply With Quote
  #3  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: Relational to datawarehouse - 08-01-2005 , 03:50 AM



And try this as well

http://www.amazon.com/exec/obidos/tg...books&n=507846

"Luis Esteban Valencia" <levalencia (AT) avansoft (DOT) com> wrote

Quote:
Can sombeody point me in the right direction. How can I convert a
relational
database to a datawarehouse?

Thanks





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.