SAS® Data Integration Studio: Fast Track
DIFAST : DIFTM7
This course introduces SAS Data Integration Studio and includes topics about change management, registering source data and target data in metadata, creating and working with jobs, and working with transformations. The course also provides information about creating iterative processes, creating conditional processes, defining new transformations, in-database processing, analyzing metadata, promoting metadata, versioning metadata, and deploying jobs.
The self-paced e-learning includes:
The self-paced e-learning includes:
- Annotatable course notes in PDF format.
- Virtual lab time to practice.
Learn How To
- View a sample job.
- Work with change management.
- Create metadata for source data, target data, and jobs.
- Work with propagation and mapping in jobs.
- Establish status handling in jobs.
- Work with various transformations (data, SQL, analysis).
- Create iterative processes with the Loop and Loop End transformations.
- Create conditional processes with the Conditional Start and Conditional End transformations.
- Create custom transformations.
- Work with the Table Loader transformation.
- Process in-database.
- Analyze metadata using impact and reverse impact analysis.
- Promote metadata.
- Version metadata by creating archives.
- Deploy jobs for scheduling.
Who Should Attend
Data integration developers and data integration architects
Prerequisites
Before attending this course, you should have experience with the following:
- SAS programming basics.
- SQL processing.
- SAS macro facility.
SAS Products Covered
SAS Analytics Platform;SAS Data Quality Solution;SAS Data Integration Studio
Course Outline
Getting Started with SAS Data Integration Studio
- Introduction to SAS Data Integration Studio.
- Exploring the course environment.
- Viewing a sample job.
- Working with change management.
- Registering SAS libraries.
- Registering SAS table metadata.
- Registering DBMS table metadata.
- Registering ODBC data source table metadata.
- Registering metadata for external files.
- Registering target data metadata.
- Importing metadata.
- Creating jobs.
- Using transformations.
- Working with the Join transformation.
- Creating the star schema.
- Working with propagation and mappings.
- Establishing status handling for transformations and jobs.
- Using data transformations.
- Using SQL transformations.
- Using analysis transformations.
- Introduction to iterative processing.
- Creating the control table.
- Creating the parameterized job.
- Creating the iterative job.
- Using control transformations.
- Creating a conditional process.
- Working with transformation templates.
- Creating custom transformations.
- Using custom transformations.
- Introduction to table loader transformations.
- Exploring load styles.
- Managing indexes and constraints.
- Introduction to in-database processing.
- Using in-database processing.
- Exploring processing techniques.
- Analyzing metadata using impact analysis.
- Promoting metadata.
- Versioning metadata.
- Introduction to deployment.
- Deploying and scheduling jobs.
Live Class Schedule
Duration: 28 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
This course isn't publicly scheduled, but private training and mentoring may be available. Contact us to explore options.
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.
This course helps prepare you to earn the following SAS Credentials:
SAS Certification Manager
SAS partners with Pearson VUE to provide you with the best possible certification experience.
Certification Resources
