|
|
|
January 2003 March 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Data Warehouse Estimation Posted by Bharat Tamhankar at 2/28/2007 6:36:45 AM Hi
Looking out for data size estimation, and server size estimation templates.
To start with data size estimation templates will also do.
Any help will be appreciated. The requirement is kind of urgent.
Regards,
Bharat...more >>
Datawarehouse best practice Posted by morphius at 2/28/2007 6:11:39 AM Typically, should the analysis services reside in the same server box where
the DW schema reside e.g. star or snowflake schema?...more >>
Regarding install analysis service Posted by Iter at 2/13/2007 9:04:01 AM Hi Guys,
I am new in analysis service. I just installed analysis service in my
personal computer that has a sql server enterprise installed. When I opened
analysis manager and try to open the server in the left pane, I got error
that no register sql server or it is not in the olap group(rough...more >>
Database Snapshot Performance Posted by Johnny at 2/12/2007 6:22:05 AM Hi,
I'm developing a Data Mart and i'm experiencing a performance gap
between my fact table and its snapshot.
I create snapshot with the istruction:
CREATE DATABASE DB_SNAP ON ( NAME = DB_SNAP_Data, FILENAME = 'C:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
\DB_SNAP_Data.ss' ) AS ...more >>
dimension with members in multiple groups Posted by Marcel Sottnik at 2/8/2007 6:24:20 PM Hallo
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 many revo...more >>
Snapshot Posted by Joe at 2/5/2007 2:43:46 PM 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 being used ...more >>
Load Schedule Posted by Joe at 2/5/2007 1:17:43 PM 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 =
it via c...more >>
telephone numbers Posted by NH at 2/5/2007 2:36:01 AM Hi there
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
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Type 2 SCD Question Posted by JP at 2/1/2007 10:31:01 AM 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
changes sales territories. Here you would need a type 2 dime...more >>
ETL / Data mart / Cube question Posted by Joe at 2/1/2007 9:16:53 AM
=B7 We are in process of using new Kimball toolkit book as our =
guide to create another DM. Since we only have one data source, we =
think we need to pull in all the tables into the staging area. At first =
we wanted to just pull in minimal data to populate the Dimension/Fact =
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |