Facets Demo New Batches Starting from Saturday... 22-10-2016
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 Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :