Slowly changing fact table?
Thu, 22 May 2008 06:00:00 -0700
The company I work for track refinery capcities around the world and what to
put this data into a data warehouse. At first glance it looks simple enough,
every quarter they take a snapshot of each refineries capacity and that is
the fact table and the dimensions would be owners, location etc.
The problem I ...
|
commander acomplia en France soft
acomplia suisse sans ordonnance
comprimes de acomplia canada
acomplia canada au rabais en ligne sans prescription
acomplia belgique en ligne
Wed, 21 May 2008 16:25:01 -0700
commander acomplia en France soft
acomplia suisse sans ordonnance
comprimes de acomplia canada
acomplia canada au rabais en ligne sans prescription
acomplia belgique en ligne
+++ PERTE DE POIDS +++ PERTE DE POIDS +++ PERTE DE POIDS +++
+
ACHETER ACOMPLIA BON MARCHE (ALL CARD ACCEPTED)
http://jhku.net/ACH ...
|
joining fact tables
Wed, 21 May 2008 11:55:18 -0700
I have two fact tables, ContractFact and FundFact.
In my DSV, I created a relationship to join them on a field that is in both,
called ContractID.
I'm having trouble figuring what to do to get the measures from both fact
tables to line up using the Dimension Usage Tab.
I would have guessed it to be a Re ...
|
Parameters in a SELECT statement (newbie)
Tue, 20 May 2008 02:09:59 -0700 (PDT)
USE [DBAdmin]
GO
/****** Object: StoredProcedure [dbo].[UpdateStockQty] Script
Date: 05/20/2008 11:02:24 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[UpdateStockQty]
(@ProductCode nvarchar(50) , @Qty float , @StockCode nvarchar(50),
@LinkQty float)
WITH
EXECUTE AS ...
|
acheter ampicillin au rabais en ligne sans prescription
achat ampicillin belgique commande en ligne
femme en termes de achat ampicillin en France
achat ampicillin canada soft generique
Achetez Le acheter ampicillin
Fri, 16 May 2008 22:53:03 -0700
acheter ampicillin au rabais en ligne sans prescription
achat ampicillin belgique commande en ligne
femme en termes de achat ampicillin en France
achat ampicillin canada soft generique
Achetez Le acheter ampicillin
+++ ANTIBIOTIQUES +++ ANTIBIOTIQUES +++ ANTIBIOTIQUES +++
+
+
http://jhku.net/BUY-AMPICIL ...
|
Reading an XML table from a SQL field
Thu, 15 May 2008 08:30:01 -0700
We have a SQL table that consists of several fields, one of which we know is
an XML dump from a table. The thing is, we don't know how to extract the
data out of the XML table that resides in this field. For example, here is a
single record of part of the table. The XML resides in the field labeled
'Data' ...
|
Fact Tables
Mon, 5 May 2008 13:09:35 -0700
Was looking at Kimball SSIS templates and note that when he is updating Fact
tables, he first dumps the original extract into an "extract" table, then in
a 2nd Data Flow area inside the same control flow, pulls that data and lines
it up with the dimension(s).
I think he's only doing it this way for auditing ...
|
|
|
NULL values and when to use 'N/A' or not to use
Wed, 30 Apr 2008 13:48:03 -0700
When profiling our data sources - we discover what OLTP sources have what
percentages of NULL values for given columns. My rule of thumb was, if the
% of null values was high - even past 50% - it wasn't too valuable to ETL in
the DW. However when smaller % of values was null, just to 'N/A' the
columns into th ...
|
Memory error reported during scheduled cube process
Mon, 28 Apr 2008 05:39:00 -0700
Hi.
I have a strange issue to my scheduled cube process.
Some days ago my cube process reported an error about missing available
memory "..memory quota estimate (xxMB) exceeds the available system memory
(xyMB).."
After reading some solutions from internet, I changed to False an advanced
parameter named M ...
|
Hierarchies and levels
Thu, 24 Apr 2008 12:44:01 -0700
Hi,
In the SSAS tutorial online Lesson 4, I am not sure what is the major
purpose of creating a "new attribute relationship" in "Dimension Structure
--> Hierarchies and levels"? I understand it is for the sorting purpose if
creating a "new attribute relationship" in the Attributes Pane. Can someone
pl ...
|
