tailieunhanh - Hands-On Microsoft SQL Server 2008 Integration Services part 48

Hands-On Microsoft SQL Server 2008 Integration Services part 48. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 448 Hands-On Microsoft SQL Server 2008 Integration Services Dimension Columns Change Type Country Historical attribute Email Fixed attribute Home Phone Changing attribute Work Phone Changing attribute Mobile Phone Changing attribute When you ve configured all the columns the wizard screen should look as shown in Figure 10-20. Click Next to move on. 16. In the Fixed and Changing Attribute Options screen uncheck the Fail the transformation if changes are detected in a fixed attribute option because we will make changes to the Email field to test how it goes. In a production environment you need to consider both of the options in this page in light of your requirements. Click Next to open the Historical Attribute Options screen. Figure 10-20 Setting change types on the dimension columns Chapter 10 Data Flow Transformations 449 17. You have two options to record a Historical attribute. If you select a single column option you can then select a column and the value pair to indicate the Current Expired or True False values. Alternatively you can select start and end dates to identify current and expired records. Select the radio button next to the Use start and end dates to identify current and expired records option. Select StartDate in the Start Date column and EndDate in the End Date column fields. Then select System StartTime in the Variable to set date values field as shown in Figure 10-21. This will update the values of StartDate and EndDate fields using the start time of the package provided by the specified system variable. Click Next. 18. By default the inferred member support is enabled in the SCD transformation and you can select from either of the two options to identify the inferred member record. In the first option you can specify null as the column values for all columns with an inferred member change type and in the second option you specify an indicator column. Select the radio button for Use a Boolean column to indicate whether the current record is an