Mail :
India : +91-8143-111-555
USA : +1-703-445-4802
uk : +44-20-3287-2021
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
Search Course Here

Live Chat
SAS DI  Online Training



This course introduces SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations.
  • SAS programming basics
  • SQL processing
  • the SAS macro facility.
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Overview of SAS Data Integration Studio
    • exploring the platform for SAS Business Analytics
    • reviewing the course data and 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 for target data
  • Creating Metadata for Jobs
    • introduction to jobs and the job editor
    • using the SQL join transformation
  • Additional Features for Jobs
    • importing SAS code
    • working with propagation and mappings
    • chaining jobs
    • investigating performance statistics
  • Working with Transformations
    • working with the extract transformation
    • working with summary statistics transformation
    • exploring 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
  • Working with Slowly Changing Dimensions
    • defining slowly changing dimensions
    • using the SCD Type 2 Loader and Lookup transformations
    • introducing the Change Data Capture transformations (self-study)
  • Working with Loop Transformations
    • introduction to Loop transformations
    • iterating a job with Loop transformations
    • iterating a single transformation with Loop transformations
  • Defining New Transformations
    • SAS code transformations
    • using the new transformation wizard
  • Working with Tables and the Table Loader Transformation
    • basics of the Table Loader transformation
    • load styles of the Table Loader transformation
    • table properties and load techniques of the Table Loader transformation
  • Additional Topics for SAS Data Integration Studio Users
    • overview
    • analyzing metadata using impact analysis
    • metadata promotion
    • metadata reports
    • checkpoint/restart
    • deploying jobs for scheduling
    • deploying jobs as SAS Stored Processes
  • Implementing Data Quality Techniques
    • SAS and data quality
    • working with the DataFlux IS transformations
SAS DI videos will be updated soon
To Watch More Videos Click Here

Flash News

AngularJS New Batch Starting From 14th NOV & 15th NOV.

Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.

IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.

Informatica Dev New Batch Starting From 17th NOV & 18th NOV.

Mean Stack New Batch Starting From 18th NOV & 19th NOV.

SAP BODS new Batch Starting From 19th NOV & 20th NOV.

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV

Tableau New Batch Starting From 21st NOV & 22nd NOV


(1) Workday Technical Demo Training

Demo Schedule : 09:30 P.M EST / 08:30 P.M CST / 6:30 P.M PST on 13th NOV & 07:00 A.M IST on 14th NOV

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :