- Home
- SAS Data Integration Studio: Additional Topics
SAS Data Integration Studio: Additional Topics
This course expands on the knowledge learned in SAS Data Integration Studio: Essentials and provides additional information on setting up change management, working with the Loop transformations, working with slowly changing dimensions, using the loader transformations, working with databases, and defining custom transformations.
Power up your staff’s skills and boost your business
About Program
Format of Training
Training Features
Course Curriculum
Course Fees
Watch
ContactAbout Program
This course expands on the knowledge learned in SAS Data Integration Studio: Essentials and provides additional information on setting up change management, working with the Loop transformations, working with slowly changing dimensions, using the loader transformations, working with databases, and defining custom transformations. Also covered are impact analysis, conditional execution, metadata promotion, and version control, as well as establishing checkpoints. Lastly, this course covers deploying jobs for scheduling and integrating with DataFlux.
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.
Format of Training
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.
Training Features
- set up change management
- work with slowly changing dimensions
- work with Loop transformations
- create new transformations
- examine impact analysis
- examine exporting and importing of metadata
- establish checkpoints
- deploy jobs for scheduling
- deploy jobs as SAS Stored Processes.
Course Curriculum
Overview of SAS Data Integration Studio
- exploring the platform for SAS Business Analytics
- introduction to SAS Data Integration Studio
- introduction to the course data and course tasks
- reviewing propagation and mapping
Working with Change Management
- introducing change management
- establishing a change management environment
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 transformation
- introducing the Change Data Capture transformations (self-study)
Creating Custom Transformations
- SAS Data Integration Studio transformations
- using the new transformation wizard
Working with the Table Loader Transformations
- reviewing the basics of the Table Loader transformations
- exploring the load styles of the Table Loader transformation
- managing indexes and constraints during loading
- bulk loading 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
- exploring metadata promotion
- exploring 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)
- SAS and data quality
- using the DataFlux transformations
Course Fees
Are you ready to take on SAS Data Integration Studio: Additional Topics?
Let’s get you started with one of the learning paths.
Find My Path Popular Courses
SAS® Academy for Clinical Programming 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.