Viewing 15 posts - 736 through 750 (of 1,353 total)
The MS stack is available in the developer's edition. It's very inexpensive as an investment in your career. Read Ralph's Kimballs data warehouse books and start learning.
July 10, 2014 at 7:43 am
You could also do work for yourself on the side to learn the tools. I've had several candidates for an open position tell me they are interested in BI,...
July 10, 2014 at 6:55 am
I have also looked and not been able to find anything. And although in general I'm a big fan of Ralph Kimball's books, I find it disappointing that he...
June 25, 2014 at 7:26 am
It's hard to argue against the rule as it applies to the management of resources towards the completion of multiple projects. Yes, project A can be done faster, but...
May 5, 2014 at 9:22 am
there are tasks which do justify the use of cursors
I'm sure this is true, but I haven't run into one yet. Once I thought I had, but I...
April 2, 2014 at 7:45 am
So, I'll ask again. How does this method compares to the use of a MERGE command
I don't know that where I could use the MERGE I would use EXCEPT....
March 26, 2014 at 7:14 am
Yes. When comparing very large data sets, your example would perform poorly. See my earlier post for more details.
I personally have found this method to be very fast. ...
March 25, 2014 at 2:15 pm
I've found the EXCEPT command to be also helpful inserting rows. I compare thousands of incoming phone numbers against millions that have already been entered. All I want...
March 25, 2014 at 8:25 am
SSAS is to store information to be retrieved on a large scale. So in your situation, it seems that it depends. If the data is already in an...
March 24, 2014 at 7:04 am
@aaron.reese
I will have to reconsider how I do that. Thanks for the information.
March 21, 2014 at 6:51 am
My only other alternative is to add create 60 fact rows for each existing row, which creates its own set of problems...
It's not clear to me why you'd do this,...
March 6, 2014 at 8:14 am
I´m reading this post a little bit late but I can recommend you this new book:
Expert Cube Development with SSAS
The poster identified that in his original post as one that...
March 3, 2014 at 9:15 am
EricEyster (3/3/2014)
--------------------------------------------------------------------------------
... but the Kimball design assumes your users are getting data from the relational engine.
I disagree with that statement. Sure, the relational data warehouse containing the dimension and fact...
March 3, 2014 at 7:13 am
Kimball design assumes your users are getting data from the relational engine
Would you mind explaining further what you mean by this? It's possible that I'm not understanding something, but...
March 3, 2014 at 6:40 am
I also maintain a pair of dates as well as a current flag. On the current records the end date is null however. On my agent tables, which...
February 28, 2014 at 7:43 am
Viewing 15 posts - 736 through 750 (of 1,353 total)