SAS DI
1 Courses 2 Projects 20 Hours
Overview
SAS DI (Data Integration Studio) is an ETL tool for visual designing. It works irrespective of any data source, platform or the applications and allows to build, implement and manage data with ease. It also improvises the changes that are likely to happen during a data integration process. It captures the information from any source and displays it easily to the users.
SAS DI includes topics for registering sources and targets, creating and working with jobs and working with transformations.
Course Fee
Key Features
- Flexible Schedule
- 24 x 7 Lifetime Support
- Certification
- Instructor Led Training
Curriculum
- Define the architecture of the platform for SAS Business Analytics.
- Describe the available interfaces.
- Define the change management feature of SAS Data Integration Studio.
- Define administrative tasks to be performed for SAS Data Integration Studio.
- Describe the New Library Wizard.
- Use Register Tables wizard to register source data.
- Use Register Tables wizard to register metadata for a Microsoft Access database table using ODBC.
- Register metadata for a comma-delimited external file.
- Import and Export Metadata.
- Describe features of the New Tables wizard.
- Discuss SAS packages.
- Discuss importing and exporting of relational metadata.
- Discuss components of SQL Join’s Designer window.
- Investigate mapping and propagation.
- Work with performance statistics.
- Generate reports on metadata for tables and jobs.
- Define Impact and Reverse Impact Analysis.
- Discuss and use the Extract and Summary Statistics transformation.
- Discuss and use the Loop transformations.
- Investigate where status handling is available.
- Discuss and use the Data Validation transformation.
- Discuss and use the Rank, Transpose, Append, List and Sort transformations.
- Discuss and use the Apply Lookup Standardization transformation.
- Define the Concept of a Checkpoint.
- Discuss reasons to use the Table Loader transformation.
- Discuss various load styles provided by the Table Loader transformation.
- Discuss various types of keys and how to define in SAS Data Integration Studio.
- Discuss indexes and how to define in SAS Data Integration Studio.
- Discuss Table Loader options for keys and indexes.
- List the functions of the SCD Type 2 transformation.
- Define business keys.
- Define surrogate and retained keys.
- Detect and track changes.
- Discuss the Lookup transformation.
- Define SAS code transformation templates.
- Create a custom transformation
- How to take the back up of jobs
- How to schedule jobs
Certification
SAS DI Certification
SLearn certification is awarded, after successful completion of the project work which shows that trainee have learned, achieved skills and experiences from the project. All the acknowledged trainees are therefore eligible for challenging projects and better job opportunities in MNC's like TCS, IBM, Cisco, Cognizant, Wipro, Dell etc.
Faq's
Other Courses
Free Career Counselling
We are happy to help you
- About Us
- Careers
- Blog
- Become an Instructor
- Corporate Training
- Contact Us
Useful Links
Copyright © 2021 SLearn - All Rights Reserved.