FL -- Miami SQL Server DW/BI/SSAS/SSIS job opening
Sat, 8 Dec 2007 17:12:59 -0500
Title: Sr. SQL Server Data Warehouse & BI Engineer
Skills: Data Warehouse fact/dimension methodology, MDX/SQL, TSQL, tuning &
troubleshooting, documentation, SQL Server 2005 BI Suite (SSAS, SSIS), some
Oracle experience (sqlldr, imp/exp).
Date: 12-3-2007
Location: Miami Lakes, FL
Area code: 305
Tax term ...
|
Deleting data slice of sql server olap partition
Sat, 8 Dec 2007 07:33:10 -0800 (PST)
Hi,
I have a situation where i have set data slice and now which has to
be
removed. I want to automate it and want to remove/ delete the data
slice on these partitions as the number of databases and also the
partitions in the cubes is huge. Could anyone help me out with any
DSO
script that would do this tak ...
|
SSIS multiple databases
Fri, 07 Dec 2007 10:48:13 +0000
Hi all
I'm trying to find something smart :) but let me first explain situation
I've couple databases with the some structure
Is there any way to run the same SSIS packages parallel against those
databases . Ideally the packages should be controlled by master package
but number od the databases can be var ...
|
FACT table design problem--banking domain
Tue, 4 Dec 2007 09:15:22 -0800 (PST)
Our customer is from foreign exchange department of the bank.
Because they never have a DW project experience before,
they don't know their requirement.
We collect their OLTP system snapshots to understand their business
and what columns on the screen might interest them.
I have a question about designing fac ...
|
automation
Mon, 3 Dec 2007 11:26:02 -0800
How can I import an xml file to SQL 2005 at the same time every night? I
will need to create a new database first via the import after that I will be
appending to the dataabase. Then I will need to xport the data into a
different xml file and upload to my hosting system which is yahoo. All so the
original ...
|
Re: Audit question
Thu, 29 Nov 2007 11:32:19 -0000
The way I use audit dimensions is both as a standalone table as you describe but also to join on fact tables. I tend to design audit dimensions at the level of each ETL run. This is useful because in the audit table you can store data lineaging-type information (when the data was loaded, which version of the load/ETL s ...
|
Min Problem
Wed, 28 Nov 2007 20:26:34 -0500
my data looks like the following
111 0 01/01/2007
111 0 02/01/2007
222 0 04/01/2007
222 0 05/01/2007
555 1 06/01/2007
666 0 06/01/2007
how can i retrieve the following???
111 0 01/01/2007
222 0 04/01/2007
555 1 06/01/2007
666 0 06/01/2007
...
|
|
|
Query Question
Wed, 28 Nov 2007 19:24:42 -0500
my data looks like the following
111 0 01/01/2007
111 0 02/01/2007
222 0 04/01/2007
222 0 05/01/2007
555 1 06/01/2007
666 0 06/01/2007
how can i retrieve the following???
111 0 01/01/2007
222 0 04/01/2007
555 1 06/01/2007
666 0 06/01/2007
...
|
Duplicate Date in Time Dimension
Mon, 26 Nov 2007 15:06:05 -0800
I've migrated from AS2K SSAS2k5 and my Time dimesions did not carry over very
well. So, I'm recreating the time demision from scratch as a regular
dimension. Tell me if I'm going down the wrong road or another way to do
this (multiple hierarchies, etc)...
I have a time Dimension that has (Current Month, L ...
|
Storing Files
Mon, 26 Nov 2007 10:31:09 -0600
I have a need to maintain data that surrounds files, there will be a large
number of files 4Kb to 10 MB in size. These files are not modified once
they are stored. I am looking for definative reasons that I should not
store these files in the database. I am using SQL '05.
Thank you
...
|
