This course introduces SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations.
Learn how to
- register source data and target tables
- create jobs and explore the functionality of the Job Editor
- work with many of the various transformations
- build a SAS OLAP cube and SAS Information Map (self-study).
Who should attend
Data integration developers and data integration architects
Before attending this course you should have experience with
You can gain this experience by completing the SAS Programming 1: Essentials course.
This course addresses SAS Data Integration Studio, SAS Analytics Platform software.
Introduction to the platform for SAS Business Analytics and SAS Data Integration Studio- exploring the platform for SAS Business Analytics
- working with SAS Data Integration Studio
- introduction to change management
Introduction to Course Data and Course Scenario- explaining the course data
- explaining how to define target data structures
- introduction to the course scenario
Creating Metadata for Source Data- setting up the environment
- registering source data metadata
Creating Metadata for Target Data- registering target data metadata
- importing metadata for target data
Creating Metadata for Jobs- introduction to jobs and the job editor
- using the SQL join transformation
Working with Jobs- working with propagation and mappings
- creating reports
- chaining jobs
- importing SAS Code
Working with Transformations- working with the extract transformation
- working with summary statistics transformation
- explore status handling for transformations and jobs
- working with the data validation transformation
- working with the sort transformation
- working with the append transformation
- working with the transpose transformation
- working with the apply lookup standardization transformation
Creating SAS OLAP Cubes and SAS Information Maps (self-study)- building an OLAP cube
- building an information map
