The MicrosoftВ Data Warehouse Toolkit: With SQL ServerВ 2005 and the MicrosoftВ Business Intelligence Toolset

Chapter 6: Developing the ETL System

Hands-on Example

Hands-on Example

Hands-on Example

Hands-on Example

Hands-on Example

Hands-on Example

Example 6.1: Script transform to set end dates

Example 6.2: Sample stored procedure to insert an audit row

Chapter 12: Security

Example 12.1: Data definition for the UserPermissions_SalesRep table

Example 12.2: INSERT rows that define which employees Joy can see

Example 12.3: Define a view to provide row-level security

Example 12.4: Create a temporary user to test security roles