I need to find a good tutorial that talks about building datawarehouse,
cubes, dimensions, etc. with SSAS 2005.
Many thanks for your suggests

I'm working on my first data warehouse and I'm not sure how I should
name the columns in the database.
The first phase of the data warehouse is to store a bunch of data from
one third party source.  The source contains over 100 pieces of data

I am building a DW in SQL2005.
There are many master files that are imported nightly. There is a chance
that old master file records may have been deleted (from source system) so i
need to merge all existing master file records with any records that exist in

I'm trying to use a script component to manipulate data in an Access database
to do some custom processing and output to an output row so that I can direct
the output rows to say another Access database.
To accomplish this, I created a script componet in the Data Flow section of

Has any one got any experience developing a data warehouse for financial
accounting? I'm talking, P&L, balance sheets and stuff. If you do kindly let
me know how you went about modelling your facts and dimensions from legacy
sources.