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:
- Annotatable course notes in PDF format.
- Virtual lab time to practice.
This course can help prepare you for the following certification exam(s): SAS Certified Data Integration Developer for SAS 9.
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
Before attending this course, you should have experience with the following:
- SAS programming basics.
- SQL processing.
- SAS macro facility.
You can gain this experience by completing the SAS® Programming 1: Essentials, SAS® SQL 1: Essentials, and SAS® Macro Language 1: Essentials courses.
This course addresses SAS Data Integration Studio, SAS Data Quality Solution, SAS Analytics Platform software.