SAS® Data Integration Studio: Fast Track
DIFAST : DIFTM7
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
