《SAS Data Integration Studio Fast Track》

　　Introduction 
　　
　　●exploring the platform for SAS Business Analytics
　　
　　●introduction to the Data Management applications
　　
　　●introduction to the classroom environment and the course tasks
　　
　　Working with Change Management 
　　
　　●introduction to change management
　　
　　●establishing a change management environment (Self-Study)
　　
　　Creating Metadata for Source Data 
　　
　　●setting up the environment
　　
　　●registering source data metadata
　　
　　Creating Metadata for Target Data 
　　
　　●registering target data metadata
　　
　　●importing metadata
　　
　　Creating Metadata for Jobs 
　　
　　●introduction to jobs and the job editor
　　
　　●using the Join transformation
　　
　　Orion Star Case Study 
　　
　　●defining and loading the customer dimension table
　　
　　●defining and loading the organization dimension table
　　
　　●defining and loading the time dimension table
　　
　　Additional Features for Jobs 
　　
　　●importing SAS code
　　
　　●propagation and mapping
　　
　　●chaining jobs
　　
　　●performance statistics
　　
　　●metadata reports
　　
　　Working with Transformations 
　　
　　●using the extract and summary statistics transformations
　　
　　●exploring SQL transformations
　　
　　●establishing status handling
　　
　　●using the Data Validation transformation
　　
　　●using the Transpose, Sort, Append, Rank, and List Data transformations
　　
　　●using the Apply Lookup Standardization, Standardize with Definition and One-Way Frequency transformations(self-study)
　　
　　Working with the Loop Transformations 
　　
　　●introduction to the loop transformations
　　
　　●iterating a job
　　
　　●iterating a transformation
　　
　　Working with Slowly Changing Dimensions 
　　
　　●defining slowly changing dimensions
　　
　　●using the SCD Type 2 Loader and Lookup transformations
　　
　　●using the SCD Type 1 Loader transformations
　　
　　●introducing the Change Data Capture transformations (self-study)
　　
　　Creating Custom Transformations 
　　
　　●using the new transformation Wizard
　　
　　●using the new transformation wizard
　　
　　Working with the Table Loader Transformations 
　　
　　●exploring the basics of the Table Loader transformations
　　
　　●exploring the load styles of the Table Loader transformation
　　
　　●managing indexes and constraints during loading
　　
　　●exploring bulk loading for DBMS tables
　　
　　Working with Databases 
　　
　　●introduction to In-Database processing
　　
　　●using In-Database processing
　　
　　●exploring ELT processing
　　
　　●using DBMS functions
　　
　　Additional Topics for SAS Data Integration Studio Users 
　　
　　●overview
　　
　　●analyzing metadata using impact analysis
　　
　　●comparing tables
　　
　　●conditional execution
　　
　　●metadata promotion
　　
　　●version control
　　
　　●establishing checkpoints
　　
　　Deploying Jobs 
　　
　　●introduction
　　
　　●deploying jobs for scheduling
　　
　　●deploying jobs in batch
　　
　　●deploying jobs as stored processes
　　
　　Implementing Data Quality Techniques (self-study) 
　　
　　●verifying data quality settings
　　
　　●using the DataFlux transformation