Training The Digital Workforce of Tomorrow.
SAS-DIFTM8 | SAS® Data Integration Studio: Fast Track



5 Day(s)

Instructor-Led Training

from SGD $4180*

Course Schedules

13 May 2024 - 17 May 2024

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

Course Overview

This course covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics. It introduces and expands the knowledge of SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also provides information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.

Who Should Enrol?

Data integration developers and data integration architects

Course Outcome

After completing this course, students will be able to:

• Register source data and target tables.
• Create jobs and explore the functionality of the Job Editor.
• Work with a variety of transformations.
• Work with slowly changing dimensions.
• Work with Loop transformations.
• Create new transformations.
• Examine impact analysis.
• Examine exporting and importing of metadata.
• Establish checkpoints in a job flow.
• Deploy jobs for scheduling.
• Deploy jobs as SAS Stored Processes.


Module 1: Introduction

Module 2: Creating Metadata for Source Data

Module 3: Creating Metadata for Target Data

Module 4: Creating Metadata for Jobs

Module 5: Additional Features for Jobs

Module 6: Orion Star Case Study

Module 7: Working with Loop Transformations

Module 8: Creating Custom Transformations

Module 9: Working with the Table Loader Transformation

Module 10: Working with Databases

Module 11: Additional Topics for SAS Data Integration Studio Users

Module 12: Deploying Jobs


Related Courses

You might also be interested in these courses

SAS-SVSO22 | SAS® Visual Statistics on SAS® Viya: Interactive Model Building
SAS-SQ1M6 | SAS® SQL 1: Essentials
SAS-EG182 | SAS® Enterprise Guide 1: Querying & Reporting
AVWSQ-SASPG1 | WSQ - SAS® Programming 1: Essentials
SAS-SVTA22 | SAS® Visual Text Analytics on SAS® Viya
SAS-ROSI35 | SAS® Viya® and R Integration for Machine Learning