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 |