A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
1
vote
2answers
86 views
sql server 2008 execution plan different on two production servers
We have two servers running SQL server 2008 R2, with identical databases, where we implemented a datawarehousing solution. The cube processing operation was taking a VERY long time in one of the ...
0
votes
2answers
48 views
Can a surrogate key and a primary key be in the same table?
For example we have:
Surrogate key: ABC123
Primary key: 1
Name: James
Is this legit in a Data Warehouse table?
3
votes
1answer
68 views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
2
votes
1answer
706 views
ALTER TABLE SWITCH statement failed
ALTER TABLE SWITCH statement failed because column does not have the same ANSI trimming semantics in tables...
Does anyone knows how to fix that on already existing table full of data?
Well, I've ...
3
votes
0answers
102 views
Where and how to store my weird datamart
I could really use some help here.
Here's my situation.
I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
3
votes
0answers
116 views
Is SQL Server data compression categorically good for read-only databases?
Some literature on SQL Server data compression I read state that the write cost increases to about four times what would normally be required. It also seems to imply that this is the primary downside ...
1
vote
0answers
54 views
Advices for modeling facts, time hierarchies based on two conditions
Sorry if my question does not belong to that SE but I tried to find the best place and it ended up here.
My problem is this :
I've got a table modeled as this in our datawarehouse env. :
MYTABLE ...
1
vote
0answers
23 views
Monoblock, Multiblock queries?
What exactly mean the terms monoblock / multiblock queries in data warehouses when talking about materialized views? Does a monoblock query just use one data source (a normal table) while a multiblock ...
0
votes
0answers
30 views
How to handle “many columns” in OLAP RDBMS
I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store this in to a column-oriented DB and perform cube analysis on it.
I tried to design a star ...
0
votes
0answers
24 views
SAP Business Warehouse 0APO_LOCNO_ATTR datasource extraction
We are currently importing 0APO_LOCNO_ATTR from several different source systems. I want to be able to import the field PRECISID into BW from this datasource. Here is what I have discovered/tried so ...
0
votes
0answers
68 views
Oracle Change Data Control - how to use SOURCE_COLMAP$ and TARGET_COLMAP$
Has anyone successfully used the TARGET_COLMAP$ column in Oracle Change Data Control to identify which columns have changed? I'm trying to produce audit reports for users and identify for the user ...
