| Thread | Last Post | Replies |
|
| Fact table changes | 29 Nov 2007 12:20 GMT | 1 |
Our data mart is medical based type of subjects.
Recently; the government changed how some "hours" of service could be
provided to certain people. The "hours" value is stored in a Fact table.
So for example; Client XYZ used to have 50 hours; it may have 63 now.
|
| Query Question | 29 Nov 2007 07:12 GMT | 2 |
my data looks like the following
111 0 01/01/2007
111 0 02/01/2007
222 0 04/01/2007
|
| how to cut some character from a string | 16 Nov 2007 20:19 GMT | 1 |
dear sir/madam
can u tell me how to cut an specified no of character form any
string in sql server
for example
|
| Fact Table design question | 16 Nov 2007 08:33 GMT | 2 |
Can a degenerate dimension act a a primary key in a fact table when a
composite of the foreign keys (linking to dimensions) doesnt form a
unique key?...The fact's granularity is at the line level and
aggregating is not an option...
|
| creating a partition table in developer edition (2005) | 12 Nov 2007 14:31 GMT | 1 |
I have 2 environments i work on , one is SQL server 2005 enterprise
edition and the other is developer edition (both with Service Pack).
i have a scripts creating a partition table who runs well on the
Enterprise version but when i run it over the Development server it
|
| SQL 2005 Analysis Services and data encryption | 07 Nov 2007 23:59 GMT | 2 |
We've got a database which contains encrypted data. To encrypt and decrypt
the data we use 3DES algorithm which is encapsulated into a C# assembly. How
do we incorporate this algorithm into SSAS? We SSAS as the backend for the
reporting services so it's important that reporting ...
|
| SQL 2005 Analysis Memory requirement | 07 Nov 2007 22:57 GMT | 1 |
We are planning to purchase hardware for Analysis Server. I want to see
what configuration everyone is using for the Analysis Server. How much RAM
on your server, how many processors, size of the cub, Server edition, etc...
Someone indicates that we need 64 bit SQL Server 2005 ...
|
| Parent-child dimension related to fact table | 05 Nov 2007 11:16 GMT | 1 |
is it possible to use a "regular relation" to connect fact table to a
parent-child dimension?
thanks
|
| Parent-child dimension | 05 Nov 2007 11:16 GMT | 1 |
I'm trying to connect a parent-child dimension to my fact table.
I would like to browse cube measure (sold items quantity) through the
dimension "Groups" representing items family (tree structure).
Here are the tables:
|
| BULK INSERT performance | 03 Nov 2007 19:05 GMT | 15 |
Question/sanity check about BULK INSERT performance.
I load a 300,000 row text file into my largest table every day. The file loads into an empty table with the same structure and
defaults but no indexes in about 10 seconds, for a rate of 30,000 rows/sec. The same file takes ...
|
| Relational Views as Transformation Method in Data Warehouse | 03 Nov 2007 18:15 GMT | 5 |
Open Question:
A recent post-reply, one expert (Marco Russo) indicated that he doesn't like
to use relational views as a quasi-ETL method, but rather prefers real
data-moving ETL to de-couple OLTP data from DW Data. I do agree with the
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread