Viewing 15 posts - 991 through 1,005 (of 1,353 total)
I've used schemas to segregate what function as temp tables. No joins so they are easily truncated. I've also got a handful of very specific client related tables...
February 21, 2011 at 6:02 pm
Typing "SSAS Date Dimension" into the google search bar yielded a lot of results.
February 16, 2011 at 2:26 pm
You might be able to find information on line. If you are going to do dimensional modeling, however, I would recommend The Data Warehouse Toolkit. I have found...
February 16, 2011 at 1:29 pm
The month should already exist as a seperate column that has already been created on the underlying table. You then would take that information and turn it into a...
February 16, 2011 at 12:29 pm
I've used the inherent SCD component for my ETL with no issues. I don't have a particularly large download each time, and I have read that for high performance...
February 3, 2011 at 1:14 pm
I agree that the above is an even better solution than I had proposed.
February 1, 2011 at 10:00 am
I don't think the answer is to create another table. The creation of tables is dependant on the relationship. If 1:1, then another table is not the answer....
February 1, 2011 at 7:30 am
It should be noted that the use of partitions for incremental processing is only available in the Enterprise and Developer versions. This will not be possible in Standard.
January 21, 2011 at 3:31 am
This mean that my Fact Tables now are linked to my Dimension Tables via the -1 value wherever there is a NULL value.
You may ultimately want to have more than...
January 19, 2011 at 3:14 am
You definitely want to seperate the date and the time dimensions. As you only seem to need 15 minute increments, you could do the time that way, but you...
January 19, 2011 at 3:09 am
DimTable has CKey and SourceKey as its combined PK.
Dimension tables should have their own computer generated key. This key would get joined to the fact table. This dim...
January 18, 2011 at 8:50 am
I agree that you have to have some kind of unknown bucket, but you may want to consider two unknown buckets. The first one is for a value that...
January 11, 2011 at 6:16 am
I would suggest that you could try tying this particular date dimension to a view. The view would join to the fact table and would therefore act as a...
January 11, 2011 at 6:09 am
You need a distinct quarters attribute. I have in my DW both an indistinct quarters and distinct. Months are the same. I have attached the output from...
January 6, 2011 at 10:08 am
It sounds as if you don't yet have a framework. I would suggest that you start with "The Data Warehouse Toolkit" by Ralph Kimball for a good overview. ...
January 4, 2011 at 3:14 am
Viewing 15 posts - 991 through 1,005 (of 1,353 total)