Microsoft® SQL Server® 2012 Bible

1147 Chapter 51: Business Intelligence Database Design 51 Instead of placing the product, productcategory, and productsubcategor ...

1148 Part IX: Business Intelligence FIGURE 51-3 Simple Dimension Load from SSIS. c51.indd 1148c51.indd 1148 7/31/2012 10:28:42 A ...

1149 Chapter 51: Business Intelligence Database Design 51 FIGURE 51-4 Fact load using SSIS. Loading Dimensions The source data h ...

1150 Part IX: Business Intelligence Unfortunately, this is not always the case. You may encounter a scenario in which you need t ...

1151 Chapter 51: Business Intelligence Database Design 51 As with the dimensions tables, you should copy the source data for the ...

1152 Part IX: Business Intelligence ■ (^) Type 1: Similar to type 0, history is not tracked. Therefore, if a change occurs to th ...

1153 Chapter 51: Business Intelligence Database Design 51 FIGURE 51-6 When a row is inserted and a version of that row exists, t ...

c51.indd 1154c51.indd 1154 7/31/2012 10:28:43 AM7/31/2012 10:28:43 AM http://www.it-ebooks.info ...

1155 CHAPTER 52 Building, Deploying, and Managing ETL Workfl ows in Integration Services IN THIS CHAPTER Using New SSIS Features ...

1156 Part IX: Business Intelligence What’s New in Integration Services for SQL Server 2012? A lot. SSIS began with SQL Ser ver 2 ...

1157 Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services 52 There are some other enhancements w ...

1158 Part IX: Business Intelligence FIGURE 52-2 Target table in Adventureworks (two views, one including the foreign key referen ...

1159 Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services 52 The SSIS Designer In the middle of ...

1160 Part IX: Business Intelligence The Toolbox To the left of your screen is the SSIS Toolbox, which is new in SSIS in SQL Serv ...

1161 Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services 52 Expression. For example, the Connec ...

1162 Part IX: Business Intelligence When the connection is defi ned by a Connection Manager, it can be referenced by other ele- ...

1163 Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services 52 FIGURE 52-6 Flat File Connection Ma ...

1164 Part IX: Business Intelligence FIGURE 52-7 An OLEDB Connection Manager Editor. You have started with one Data fl ow task an ...

1165 Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services 52 Double-click the Derived Column tr ...

1166 Part IX: Business Intelligence Select Production.ProductReview for the Name of the Table or the View. Click Mappings. Eith ...