SAS DI (DATA INTERATION) ONLINE TRAINING COURSE IN INDIA

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

CONTACT US