hi, does anyone no much about data warehouse? and what sort of difficulties would a dba face during the process of designing and loading a data warehouse?thanks

I know that 9/10 data warehouse projects fail becuase the developers, dbas, or management do not understand the concept of a data warehouse.

Read some of the books on datewarehousing by Bill Inmon.

Start small, with just a few tables, and then manage the growth and complexity of the schema through an interative process of consulting with the end-users.

The single biggest mistake you can make is to try to plan and design the entire data warehouse at once.

blindman

Check out Ralph Kimball's books.

For anyone still dropping into this topic:

IBM Redbook on DW

http://publib-b.boulder.ibm.com/Redb...5415.html?Open