SAS Data Integration Studio: Fast Track

This course is a boot camp that covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics.

Duration 4 Days
Certificate SAS Global
Language English

Fees 60000 + taxes


Power up your staff’s skills and boost your business

or Call us on +91 79 403 270 00


Course Description

Data integration developers and data integration architects

About Program

This course is a boot camp that 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 covers information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.

The self-study version of this course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

  • digital course notes for self-study
  • Virtual Lab: 50 hours of hands-on software practice.

 

This course can help prepare you for the following certification exam(s): SAS Data Integration Development for SAS 9.

Format of Training

All the benefits of the classroom without the travel:

Led by an expert instructor who can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries

Classroom training options include courses offered in our regional training centers or via our Live Web classroom.

Taught by certified instructors at high-tech facilities across the country

  • A SAS expert at your side.
  • Focused learning away from the office
  • Networking opportunities
  • State-of-the-art facilities
  • Electronic course notes downloadable to your device and permission to print
  • Business Knowledge Series: in-depth courses on the latest business topics
  • We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.

Prerequisite

Before attending this course, you should have experience with

  • SAS programming basics
  • SQL processing
  • the SAS macro facility.

Training Features

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
  • work with slowly changing dimensions
  • work with Loop transformations
  • create new transformations
  • examine impact analysis
  • examine exporting and importing of metadata
  • establish checkpoints in job flow
  • deploy jobs for scheduling
  • deploy jobs as SAS Stored Processes.

Course Curriculum

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

Project

  • setting up the environment
  • registering source data metadata
  • registering target data metadata
  • importing metadata

FAQs

Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.

Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.

Course Fees

Classroom

  

  

60000

+ Applicable Taxes
Enroll Now

Live Web

  

  

60000

+ Applicable Taxes
Enroll Now