MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® V11 - Business Intelligence Development and Maintenance
Publisher: Microsoft Press
Released: February 2009
Pages: 688
Description
Product Details
About the Author
Recommended for You
Recently Viewed
Microsoft® SQL Server® 2008 Internals
By Kalen Delaney, Paul Randal, Kimberly Tripp, Conor Cunningham
March 2009
Ebook: $47.99
Print & Ebook: $65.99
Print: $59.99
The Debian System, 2nd Edition
By Martin F. Krafft
Agile Project Management with Scrum
By Ken Schwaber
February 2004
Ebook: $31.99
Print & Ebook: $43.99
Print: $39.99
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
Microsoft Press MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® V11 - Business Intelligence Development and Maintenance
 
4.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

REVIEWS

Reviewed by 1 customer

Displaying review 1

Back to top

(1 of 1 customers found this review helpful)

 
4.0

Null GeographyKey data in DimCustomer?

By Brian

from Bronx, NY

About Me Developer

Verified Reviewer

Pros

  • Well-written

Cons

  • Not comprehensive enough

Best Uses

  • Intermediate

Comments about Microsoft Press MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® V11 - Business Intelligence Development and Maintenance:

(Copy of review posted to Amazon.com)

Having gone through the first 8 chapters, I feel I've learned quite a bit from this training kit and especially the practice exercises. But in performing Exercise 1 of Chapter 9's Lesson 1 practice, I found that the GeographyKey of every record in DimCustomer is NULL. As a result, the view dbo.vDMPrep (which is defined as an inner join on GeographyKey to DimGeography) returns no records.

As a workaround, I considered altering the dbo.vDMPrep view to exclude the inner join on GeographyKey but dbo.vTargetMail relies on the SalesTerritoryGroup field from DimSalesTerritory (which is joined on SalesTerritoryKey to DimGeography in vDMPrep).

I don't know if anyone else found a way around the problem, but it appears that this was reported to Microsoft Press on October 25, 2010 by jomaweb, according to the O'Reilly web site. It would be nice if O'Reilly or Microsoft Press could respond with the status of this error.

Displaying review 1

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Save a Tree - Go Digital  what is this?
Print & Ebook: $76.99
Print: $69.99