In designing a data warehouse I understand the importance of the
dimension/fact relationship.   I also understand why you would need type 2
dimensions.
The example I have seen over and over again demonstrates when a sales person

We have an existing data mart where it's load cycle is the first Saturday of every month.   Besides making the data available quicker, are there more pro's to shortening the load cycle to every day or once a week?  It's a very small data mart with most users (under 10) accessing ...

We are getting this error: 'ADODB.Connection: Provider is not specified
and there is no designated default provider' on a 64 bit machine with
both Sql 2K 32bit and Sql 2K5 64bit installed. It happens from Vbscript
that backs up our Olap databases.  The script (below) works fine ...

I need to implement geographic dimension, which should be able to group regions into region groups. Though, it must be
possible to have one region in multiple region groups simultaneously. It's a typical application mentioned in this
excellent document from Marc Russo "Many to ...

One of the first steps in creating an ETL for a data mart - is moving data from the source system into a staging area.
A current system we have now - copies all data, all tables and values, and replaces the staging area each time it is ran - even tables and values that aren't ...

I am loading csv files containing call data records (CDRs) into a database
which I want to incorporate into a data warehouse..
The problem I have is that the telephone numbers are not standard i.e. the
existing tables all store telephone numbers in the format '+441234567890' but