Courses Info

SAS DI STUDIO (Data Integration Studio)

  • Exploring SAS Data Integration Studio
  • Working on Change Management
  • Explaining how to define source, target data structures and designing jobs.
  • Introduction to jobs and the job editor
  • Working with propagation and mappings
  • working with intermediate files
  • working with the extract transformation
  • working with summary statistics transformation
  • explore 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
  • iterating a job with Loop transformations
  • basics of the Table Loader transformation
  • load styles of the Table Loader transformation
  • table properties and load techniques of the Table Loader transformation
  • Defining slowly changing dimensions
  • Using the SCD type 2 Loader and Change Data capture transformations (Pre & Post Process).
  • analyzing metadata using impact analysis