- Home
- SAS Data Integration Studio: Fast Track
SAS Data Integration Studio: Fast Track
This course is a boot camp that covers the content of both SAS Data Integration Studio: Essentials and SAS Data Integration Studio: Additional Topics.
Power up your staff’s skills and boost your business
Course Description
About Program
Format of Training
Prerequisite
Training Features
Course Curriculum
Project
FAQs
Course Fees
Watch
ContactCourse Description
Data integration developers and data integration architects
About Program
This course is a boot camp that covers 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 includes topics for registering sources and targets; creating and working with jobs; and working with transformations. This course also covers information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.
The self-study version of this course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.
The e-learning includes:
- digital course notes for self-study
- Virtual Lab: 50 hours of hands-on software practice.
This course can help prepare you for the following certification exam(s): SAS Data Integration Development for SAS 9.
Format of Training
Live Web Classroom
Training is Led by an expert instructor live online using live web training platform, and this are not pre recorded lectures. Trainer can virtually look over your shoulder. Discuss, share, exchange ideas with students from different countries.
Taste of Live Web - is a perfect platform for indivudals who fear online training. SAS® gives an opportunity to all the registrants to have a closer look at different courses given below with a blend of Online Learning.
All the benefits of the classroom without the travel:
Classroom training options include courses offered in our regional training centers or via our Live Web classroom.
Taught by certified instructors at High-Tech facilities across the country:
- A SAS expert at your side.
- Focused learning away from the office
- Networking opportunities
- State-of-the-art facilities
- Electronic course notes downloadable to your device and permission to print
- Business Knowledge Series: in-depth courses on the latest business topics
- We offer Connected Classes! Watch for courses in Cary, New York, Arlington, Dallas and San Francisco that connect remote students via our Live Web classroom.
Prerequisite
Before attending this course, you should have experience with
- SAS programming basics
- SQL processing
- the SAS macro facility.
Training Features
Learn how to
- register source data and target tables
- create jobs and explore the functionality of the job editor
- work with many of the various transformations
- work with slowly changing dimensions
- work with Loop transformations
- create new transformations
- examine impact analysis
- examine exporting and importing of metadata
- establish checkpoints in job flow
- deploy jobs for scheduling
- deploy jobs as SAS Stored Processes.
Course Curriculum
Introduction
- exploring the platform for SAS Business Analytics
- introduction to the 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 transformations
- 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 transformations
- introducing the Change Data Capture transformations (self-study)
Creating Custom Transformations
- using the new transformation Wizard
- using the new transformation wizard
Working with the Table Loader Transformations
- exploring the basics of the Table Loader transformations
- 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 ELT processing
- using DBMS functions
Additional Topics for SAS Data Integration Studio Users
- overview
- analyzing metadata using impact analysis
- comparing tables
- conditional execution
- metadata promotion
- version control
- establishing checkpoints
Deploying Jobs
- introduction
- 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
Project
- setting up the environment
- registering source data metadata
- registering target data metadata
- importing metadata
FAQs
Each exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. Computer-based in format, SAS Global Certification exams comprise multiple-choice and/or short-answer questions, depending on the exam. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. Candidates are allotted varying time limits to complete the exam, depending on which exam is taken. Specific exam content and passing criteria are located within each exam. To encourage your feedback, SAS Global Certification exams include a feature that allows candidates to comment on specific test questions. Your opinions are important to us and are a critical component in test development. Additionally, SAS Global Certification requires candidates to accept the terms of the SAS Institute Inc. Certification Program CandidatCancele Agreement before taking a certification exam.
Short-answer questions require you type your answer in a text box, rather than select your answer from four options. Typically, you will provide a numeric answer or a short section of SAS programming code. When entering code, case is ignored, and all variations of SAS syntax that correctly complete the program are accepted as correct.
Course Fees
Are you ready to take on SAS Data Integration Studio: Fast Track?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
Batch Schedule SAS® Academy for Data Science Introduction to CDISC Domains & Standards Data Visualization Machine Learning & AI Data Management Data Analytics Predictive Business AnalystCertification
SAS Certified Base Programmer for SAS 9 SAS® Certified Big Data Professional Using SAS®9 Predictive Modeling certification exam SAS® Certified Clinical Trials Programmer Using SAS®9 SAS® Certified Data Scientist SAS® Certified Platform Administrator for SAS®9
© 2024 Epoch Research Institute India Pvt. Ltd. All Rights Reserved. All Contents Shown from SAS are sole propriety of © SAS Institute Inc. All Rights Reserved. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Adobe and the Acrobat logo are trademarks of Adobe Systems Incorporated.