Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support
SAS DI  Online Training

SAS DI



overview

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

Corporate
  • It is a 3 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    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
Videos
SAS DI videos will be updated soon
To Watch More Videos Click Here

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


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


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


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


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

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

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

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

PUBLIC DEMO


(1) Workday Technical Demo Training

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

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings