| Thread | Last Post | Replies |
|
| Implementing Data Warehouse | 26 Jun 2007 08:26 GMT | 4 |
Hello, all of you, DB Gurus!
I would like you to give your opinion about the way I'm implementing Data
Warehouse on my company, and the ways to enhance it.
If this is not the best place to publish it please let me know, as far as
|
| Is there a perfmon counter(s) that show the results is from cubes? | 26 Jun 2007 03:52 GMT | 1 |
How do I find out if the result is from the cube(s) with perfmon?
|
| Fact Table Design for Hours Worked | 25 Jun 2007 23:36 GMT | 4 |
I am trying to design a cube with Date, Time and Employee dimension
which can answer following questions:
- how many employees were working at 10am on 15 June 2007? I
- how many man hours were pais between 10am -11am on 15 June 2007. If
|
| referential integrity | 21 Jun 2007 21:42 GMT | 4 |
When implementing a schema for data warehousing is it common practice not to
implement referential integrity across the tables in the database?
If true is it purely for ETL purposes or does it improve query performance
if the referential integrity is not applied to the tables.
|
| Analysis Services service hangs cube build / timeout on process cu | 19 Jun 2007 02:05 GMT | 2 |
We have two apparent issues with Analysis Services (AS) as outlined below:
1. We have a rebuild of the nightly cube build and quite often the first
step would hang (just run without processing). We would have to stop the
job, restart Analysis Services and then start the job ...
|
| BI Studio: Poor Performance When Opening a Solution | 14 Jun 2007 12:29 GMT | 3 |
When I am opening a Business Intelligence Solution it takes up to 6 minutes
until the system is ready to work.
The first 4 minutes I see Visual Studio with the grey background. In the
remaining time the packages appear but don't accept any input. Meanwhile
|
| How are you documenting your ETL processes | 13 Jun 2007 23:36 GMT | 1 |
I'm currently using SSIS on a fairly large project. I wanted to know how
other developers are documenting their ETL processes. I've started using
Visio for flow charting some of my ETL processes. But I am finding it
difficult to use.
|
| SSIS Merge Join | 12 Jun 2007 21:33 GMT | 1 |
I am trying to move data from sql2000 to sql2005
In the data flow source I have
select str_seq, one_seq, one_cd, two_seq, two_cd from table1
After this I have a Mulicast with two lookups (in sql 2005)
|
| ETL and SSIS/SSAS roles in it all. | 12 Jun 2007 21:25 GMT | 1 |
I am a student in a data warehousing class. This is my only experience using
SQL Server 2005 BI ETL tools. I need to extract, transform, and load into a
data warehouse using SQL Server 2005. I've extracted all tables from my 3nf
d.b. into flat files using SSIS. My question is ...
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread