Workshop: SAS Data Integration Studio
Course Length - 2 Days
This workshop is delivered over two days. To begin with the focus is on registering data and organising the metadata environment. The workshop then moves on to cover the most important DI Studio transformations; and then the development of jobs using those transformations, in some cases in conjunction with user-written SAS code. Efficiency, maintenance, impact analysis, change management and job scheduling are also covered.
Public Course price:
£820.00 plus VAT per delegate
Workshop: SAS Data Integration Studio Public Course Dates
Due to Covid-19 all Amadeus training will be delivered via live web classes. Our live Web classes are as interactive as our classroom training, there are also some benefits - no travelling time and costs!
Audience
This workshop is designed for Computer Users familiar with the SAS® System and who wish to learn how to build and maintain jobs using SAS Data Integration Studio.
Prerequisites
Attendees will be expected to have some knowledge of SAS programming, including the SAS macro language.
Topics
DI 1 Introduction to Data Integration Studio
- Overview
- Metadata
- Metadata in SAS Management Console
- Metadata-based software development in DI Studio
- The DI Studio Interface
- Metadata folder structure
- A quick look at a job
DI 2 Registering Data
- Introduction
- Registering a library
- Registering existing tables
- Registering target tables
- Naming conventions for tables
- Table metadata and the physical table
- Registering external files
DI 3 DI Studio Transformations
- Transformations available
- Extract
- SQL Join
- Table Loader
- Sort
- Append
- Splitter
- List Data
- Lookup
- Data Validation
DI 4 DI Studio Jobs
- Job generalities
- Naming conventions
- Job Editor options
- Details Panel
- Running jobs
DI 5 Further Transformations
- The SCD Type 1 Loader
- The Loop and Loop End transforms, and looping jobs
- The SCD Type 2 Loader
- The Conditional Start and Conditional End transforms, and conditional jobs
DI 6 Including User Code
- Ways of including user code in a job
- User-Written Code Node
- Precode and Postcode
- Custom Transforms
DI 7 Change Management
- Why use Change Management?
- Creating a Project Repository
- Using a Project Repository
- Change Management Hints and Tips
DI 8 Program Development and Maintenance
- Making jobs easy to promote between environments
- Making jobs easy to modify and maintain
- Modifying a job to use different tables
- Modifying a job in other ways
- Running parts of a job
- The Code Editor
- Tables or Views?
- Macros and formats
- Impact Analysis and Reverse Impact Analysis
DI 9 Deployment and Scheduling
- Deployment and Scheduling Basics
- Deploying jobs
- Re-deploying jobs
- Building job flows
- Scheduling flows