Viewing 15 posts - 901 through 915 (of 1,354 total)
You've really got a lot here. You're not asking for someone to simply solve a problem, but to validate your design. I don't want to get into a...
January 16, 2012 at 8:37 am
I don't think you have a degerate dimension just because you are populating it from the fact table. If fifty fact rows with the same date end up inserting...
January 13, 2012 at 10:47 am
I'm still not sold to the idea
I agree. A view has it's uses, but it can make things very complicated. A field added to table would subsequently...
January 12, 2012 at 11:21 am
SSAS is a source; SSRS is a reporting tool. You can't really report using SSAS, but you can have other things connect to it besides SSRS to do reports....
January 12, 2012 at 4:18 am
For one time populations, there shouldn't be an issue with RBAR.
January 12, 2012 at 4:17 am
Why did you opt for a snowflake schema? There are limited uses for this in an OLAP design, but most designs are properly down using the star schema.
As for...
January 4, 2012 at 7:52 am
This is difficult to answer because more information would be useful. As a general rule, however, in an OLAP environment you want as much information pre-calculated as possible. ...
January 3, 2012 at 8:02 am
I'm not normally a fan of views in an OLTP environment. They have uses, but I just haven't run across that particular need.
I have found them very useful in...
January 3, 2012 at 7:53 am
My answer is whatever someone's willing to pay you after the interview, and more importantly on ongoing basis after they get to know you better.
I agree. Concentrate on...
December 22, 2011 at 7:28 am
From what I've read, data warehouses for financial institutions can be extremely complicated. So be careful. If you're a beginner, you may need outside help.
To address of couple...
December 9, 2011 at 5:50 am
I've never done an individual cube, and your suggestion seems to imply it's in the database and not SSAS. In either case, what do you think about restoring the...
December 8, 2011 at 3:14 am
The composite key could give troubles though.
I think it is best to introduce surrogate keys between those tables. It will make configuration a lot easier.
Normally I don't add something...
November 25, 2011 at 3:36 am
The main advantage for me was that this is something that is used often within queries and this solution could have made the report not hit the fact table to...
November 24, 2011 at 8:43 am
For those using 2005, I would recommend doing a left join from the staging table to the target table, including in the SELECT statement of the columns that would be...
November 24, 2011 at 8:39 am
Create a cube using it as a fact table. A table can be a dimension or fact table, though normally the relationship with other tables is the determing factor....
November 22, 2011 at 8:48 am
Viewing 15 posts - 901 through 915 (of 1,354 total)