Errata

Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012

Errata for Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
PDF Page 16
Lesson review, question 2

Question 2 asks which schema is most relevant for this kind of project, but only states that it's a POC project. The question should perhaps be updated to state it is a POC DW project.

 Dennis Verbunt  Mar 01, 2014 
PDF Page 18
United States

On page 18, 5th paragraph there is a phrase "as you saw
in the previous lesson." it should be "as you sow
in the previous lesson."

 Biz Nigatu  Feb 18, 2014 
Printed Page 294
Exercise 1, Step 5

Data Flow Task "Insert stgCustomerInformation" fails due to conversion error on "BirthDate" column.

When looking at the values of the BirthDate column in CustomerInformation.txt inside the C:\TK463\Chapter07\Code folder, they seem to be integers,such as: 1966408.

I solved the problem by replacing the above mentioned file with the CustomerInformation.txt found in the C:\TK463\Chapter05\Code folder, since that one has correct formats e.g. 1966-04-08.

Best Regards,
Daniel

 Daniel Gaudin  Mar 23, 2014 
Printed Page 296
Exercise 1, Step 21

The column "MaritalStatus" in table dbo.Customers is declared as NCHAR(5). This triggers an SCD2 on all the records that contain "N\A" on the MaritalStatus column (2289 records).

I changed the definition of "MaritalStatus" to NVARCHAR(5) in order to fix this issue.

Best Regards,
Daniel

 Daniel Gaudin  Mar 23, 2014 
PDF Page 515
3rd paragraph (and other multiple locations)

"DefaultMaxBufferRows" should be "DefaultBufferMaxRows". This error also occurs on pages 516, 523, 526. and 782.

"DefaultMaxBufferSize" should be "DefaultBufferSize". This error also occurs on pages 516, 523, and 782.

 Paul Neumann  Feb 07, 2014