.net pdf 417

.net pdf 417

.net pdf 417

.net pdf 417

.net pdf 417

.net pdf 417,

.net pdf 417,
.net pdf 417,

.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,

.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,

.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,
.net pdf 417,

Web-based product and technology information is available free from Microsoft via the Seminar Online website at www.microsoft.com/seminar (see Figure A-4). By utilizing web-based audio and video streaming technologies, visitors to this website can receive online technical content similar to that received at live conferences. The format includes descriptive slides along with voice narration. It s available on demand, and it works well even in low-bandwidth situations.

Here is a simple UPDATE statement that changes the credit limit and salesperson for a customer:

FACILITY_ATTRIBUTE_DEFINITIONS facility_ type Warehouse Warehouse Warehouse Warehouse Factory Factory Factory Factory attribute_ name attribute_1 attribute_2 attribute_3 attribute_4 attribute_1 attribute_2 attribute_3 attribute_4 attribute_definition Warehouse Manager Distribution Region Facilities for Perishables Number of Loading Docks Foreman Factory Type Clean Room Entrances

Figure A-3.

- 207 -

name, an attribute that identifies the individual in charge, and several type-specific characteristics. Figure 13-7 illustrates a facility dimension table that abstracts these type-specific attributes into a set of generic attributes. For any given row in the facility table, the meaning of each generic column is determined by the facility type. The generic column names are mapped to type-specific definitions in an auxiliary table called facility_attribute_definitions. Consulting this table, you can identify what each column indicates on a type-by-type basis. For the facility type Warehouse, for example, attribute_3 indicates whether the facility has the capability to stock perishable goods. For factories, this same column indicates whether the facility has a clean room. This design is very flexible when it comes to storing information, permitting the storage of customized attributes for a large number of types, all within a single table. Some types may make use of all of the generic attributes, while others make use of some of them. As long as there are enough generic columns of the appropriate data types, it is possible to accommodate any type. A similar technique can be used to capture variation within a fact table.

Figure A-4.

Though very flexible for storing information, a generic design is less flexible when it comes to retrieving information. Because column names are generically defined, the construction of queries requires referring to information on column content. Query results, as well, will need to be repackaged with decoded attribute labels. These activities are not directly supported by standard query and reporting software. For example, suppose the dimension table in Figure 13-7 is part of a star describing inventory levels. A report is needed that provides inventory levels for warehouses that have facilities for perishable goods, and the results will be grouped by region. Construction of a query to fetch this information will require using reference data to identify which column indicates whether the warehouse has the capability to store perishables. This turns out to be attribute_3, which can be used to constrain the query, as in:

For technical and usage support on Microsoft products, users can call Microsoft s phone-based support. Pricing structures and levels of support vary based on the product, purchased support options, and special arrangements with companies. For more information on contacting Microsoft Technical Support, see support.microsoft.com.

Raise the credit limit for Acme Manufacturing to $60,000 and reassign them to Mary Jones (employee number 109) /UPDATE CUSTOMERS SET CREDIT_LIMIT = 6000000, CUST_REP = 109 WHERE COMPANY = 'Acme Mfg' 1 row updated In this example, the WHERE clause identifies a single row of the CUSTOMERS table, and the SET clause assigns new values to two of the columns in that row The WHERE clause is exactly the same one you would use in a DELETE or SELECT statement to identify the row In fact, the search conditions that can appear in the WHERE clause of an UPDATE statement are exactly the same as those available in the SELECT and DELETE statements.

where facility.attribute_3 = 'has Perishable Storage Facilities'

If you want to learn the ins and outs of specific Microsoft products or technologies in an instructor-led classroom setting, Microsoft Authorized Technical Education courses may be for you. Classes range from half-day sessions to two-week, in-depth training. For a complete list of classes and authorized training centers, go to www.microsoft.com/train_cert (see Figure A-5). This site also provides a wealth of information for those who are seeking Microsoft certifications. Table A-1 lists the major certifications available from Microsoft. For more information on the requirements for each of these certifications, see the Microsoft Training & Certification Home Page.