SAS(R) Data Integration Studio: Fast Track

  • Tuition USD $4,000 GSA  $3,627.20
  • Reviews star_rate star_rate star_rate star_rate star_half 1076 Ratings
  • Course Code DIFT49
  • Duration 4 days
  • Available Formats Classroom
This course is in a boot-camp format. It includes the content of both SAS® Data Integration Studio: Essentials and SAS® Data Integration Studio: Additional Topics It introduces and expands the knowledge of SAS Data Integration Studio and contains topics about registering sources and targets; creating and working with jobs; and working with transformations. This course also provides information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.

The self-study e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual Lab time to practice.

Skills Gained

  • register source data and target tables
  • create jobs and use the functionality of the Job Editor
  • work with many of the transformations
  • apply slowly changing dimensions
  • work with Loop transformations
  • create new transformations
  • evaluate impact analysis
  • export and import metadata
  • establish checkpoints in job flow
  • set up jobs for scheduling
  • deploy jobs as SAS Stored Processes.

Who Can Benefit

  • Data integration developers and data integration architects

Prerequisites

  • Before attending this course, you should have experience with
  • SAS programming basics
  • SQL processing
  • the SAS macro facility.

Course Details

Introduction

  • exploring the platform for SAS Business Analytics
  • introduction to SAS Data Management applications
  • introduction to the classroom environment and the 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

Creating Metadata for Jobs

  • introduction to jobs and the Job Editor
  • using the Join transformation

Orion Star Case Study

  • defining and loading the customer dimension table
  • defining and loading the organization dimension table
  • defining and loading the time dimension table

Additional Features for Jobs

  • importing SAS code
  • propagation and mapping
  • chaining jobs
  • performance statistics
  • metadata reports

Working with Transformations

  • using the extract and summary statistics transformations
  • exploring SQL transformations
  • establishing status handling
  • using the Data Validation transformation
  • using the Transpose, Sort, Append, Rank, and List Data transformations
  • using the Apply Lookup Standardization, Standardize with Definition and One-Way Frequency transformations(self-study)

Working with the Loop Transformations

  • introduction to the Loop transformation
  • iterating a job
  • iterating a transformation

Working with Slowly Changing Dimensions

  • defining slowly changing dimensions
  • using the SCD Type 2 Loader and Lookup transformations
  • using the SCD Type 1 Loader transformation
  • introducing the Change Data Capture transformation (self-study)

Creating Custom Transformations

  • using the new Transformation Wizard

Working with the Table Loader Transformations

  • exploring the basics of the Table Loader transformation
  • exploring the load styles of the Table Loader transformation
  • managing indexes and constraints during loading
  • exploring bulk loading for DBMS tables

Working with Databases

  • introduction to in-database processing
  • using in-database processing
  • exploring extract, load, and transform (ETL) processing
  • using DBMS functions

Additional Topics for SAS Data Integration Studio Users

  • overview of additional topics
  • analyzing metadata using impact analysis
  • comparing tables
  • conditional execution
  • metadata promotion
  • version control
  • establishing checkpoints

Deploying Jobs

  • introduction to deploying jobs
  • deploying jobs for scheduling
  • deploying jobs in batch
  • deploying jobs as stored processes

Implementing Data Quality Techniques (Self-Study)

  • verifying data quality settings
  • using the DataFlux transformation

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Great personnel and facility. I just should have been told i was the only person physically in thr class, and that there was an option to attend the class remotely.

Exit Certified made the learning process fun and understandable . Highly Recommend !!!

I am very pleased with how the trainings are structured. They are very well prepared and bring a lot of value.

Sean was a fantastic instructor! He went beyond the material to help one understand!

I took the AWS Technical Essentials and it was taught very well. It was very comprehensive and the instructor was fantastic. Already having familiarity with AWS, it was still taught at a level where I felt like it was worth taking before doing taking the AWS Developer course.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward