SAS® Data Integration Studio: Fast Track

Cílová skupina

Data integration developers and data integration architects

Struktura kurzu

Getting Started with SAS Data Integration Studio

• Introduction to SAS Data Integration Studio.
• Exploring the course environment.
• Viewing a sample job.
• Working with change management.Creating Metadata for Source Data
• Registering SAS libraries.
• Registering SAS table metadata.
• Registering DBMS table metadata.
• Registering ODBC data source table metadata.
• Registering metadata for external files.Creating Metadata for Target Data
• Registering target data metadata.
• Importing metadata.Creating Metadata for Jobs
• Creating jobs.
• Using transformations.
• Working with the Join transformation.Orion Star Case Study
• Creating the star schema.Additional Features for Jobs
• Working with propagation and mappings.
• Establishing status handling for transformations and jobs.Working with Transformations
• Using data transformations.
• Using SQL transformations.
• Using analysis transformations.Creating Iterative Processes
• Introduction to iterative processing.
• Creating the control table.
• Creating the parameterized job.
• Creating the iterative job.Creating Conditional Processes
• Using control transformations.
• Creating a conditional process.Creating Custom Transformations
• Working with transformation templates.
• Creating custom transformations.
• Using custom transformations.Working with the Table Loader Transformation
• Introduction to table loader transformations.
• Exploring load styles.
• Managing indexes and constraints.Working with Databases
• Introduction to in-database processing.
• Using in-database processing.
• Exploring processing techniques.Analyzing, Promoting, and Versioning Metadata
• Analyzing metadata using impact analysis.
• Promoting metadata.
• Versioning metadata.Deploying Jobs
• Introduction to deployment.
• Deploying and scheduling jobs.