SAS DI Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

864 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Overview

  • Define the architecture of the platform for SAS Business Analytics
  • Describe the available interfaces
  • Define the change management feature of SAS Data Integration Studio
  • Discuss the DataFlux Integration Server 

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 for target data.

Creating Metadata For Target Data And Jobs

  • Describe features of the New Tables wizard
  • Discuss SAS packages
  • Discuss importing and exporting of relational metadata
  • Discuss components of SQL Join’s Designer window
  • Investigate mapping and propagation
  • Work with performance statistics
  • Generate reports on metadata for tables and jobs
  • Define Impact and Reverse Impact Analysis.

Working With Transformations

  • Discuss and use the Extract and Summary Statistics transformation
  • Discuss and use the Loop transformations
  • Investigate where status handling is available
  • Discuss and use the Data Validation transformation
  • Discuss and use the (Rank, Transpose, Append, List and Sort transformations)
  • Discuss and use the Apply Lookup Standardization transformation
  • Define the Concept of a Checkpoint. 

Working With Tables And The Table Loader Transformation

  • Discuss reasons to use the Table Loader transformation
  • Discuss various load styles provided by the Table Loader transformation
  • Discuss various types of keys and how to define in SAS Data Integration Studio
  • Discuss indexes and how to define in SAS Data Integration Studio
  • Discuss Table Loader options for keys and indexes 

Working With Slowly Changing Dimensions

  • List the functions of the SCD Type 2 transformation
  • Define business keys
  • Define surrogate and retained keys
  • Detect and track changes
  • Discuss the Lookup transformation 

Defining Generated Transformations

  • Learn, How to create a custom transformation and SAS code transformation templates.
  • Define SAS code transformation templates
  • Create a custom transformation

Course Description

What are the Course Objectives for this Training?

In this training, the participant will learn how to set up change management, work with slowly changing dimensions, work with Loop transformations, create new transformations, examine impact analysis, examine exporting and importing of metadata, establish checkpoints, deploy jobs for scheduling and deploy jobs as SAS Stored Processes. This course has been designed in such a way that it is very easy for you to acquire and expand your SAS Data Integration skills quickly. So, you can start working in this field once you complete the training successfully.

Who Should do this Course?

  • Data Analysis
  • Database Administration and
  • Database Designing background will get benefited from this course. 

What are the Pre-requisites for this Training Course?

As there are no Pre-requisites, Anyone who is having enthusiasm in learning the course can attend this Training.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Siva

I came across Live Training Bangalore while I was searching for Fast Track courses in SAS DI. Their coordinators and instructors responded positively and I was able to get a good conceptual overview. Thank you LTB.

Bhargavi

Had a Great Experience in learning the Course with LTB. The trainer has a Practical Knowledge about the subject and taught us with real-time scenarios. Thank you LTB.

Harish

It was a great experience to undergo and get certified in the SAS DI Course from LTB. As a working professional, it has not only given me an exposure to the domain but also helped me learn cross technologies and develop an inclination towards it. Thank you.