I am currently finishing off my high level structure for the new
business intelligence database system for my company and without going
into too much detail I would like to get your comments on it. Maybe
there is something you have tried that did/didn't work. Any comments

Thanks in advance
Company has a OCR scanner and it scanns a employee_info sheet.
These scanned data are appended into Empl_info table in SQL Server.
Problem is:

I reasonably new to archiving data (as is my company) and need to run a delta
extract on some data to a staging table.
I think I'm reasonably up to speed on the concepts, but what is the best way
of writing the details. Note that I'm working with SQL Server 2000.

I have done some reading on dimensional modeling and am a bit confused as to
how I create a dimension in our data warehouse using our transactional source.
I have a customer table which contains the customer id, customer name,
region codes and industry codes.   Naturally I also ...