• Print  |
  • Feedback  |

Training & Books

globe

SAS Global Certification program


Platform Administrator

SAS Certified Data Integration Developer for SAS 9 Credential

Tests the candidate's ability to apply the skills and knowledge necessary for Data Integration Development in the SAS environment

Successful candidates should be skilled in tasks such as
  • defining architecture of the platform for SAS Business Analytics
  • creating metadata for source and target data
  • creating metadata for target data and jobs
  • working with transformations
  • working with tables and table loader transformation
  • working with slowly changing dimensions
  • defining generated transformations
  • deploying jobs.

Required Exam

Candidates who earn this credential will have earned a passing score on the SAS Data Integration Development for SAS 9 exam. This exam based on SAS 9.3 using Data Integration Studio 4.4 and is administered by SAS and Pearson VUE.
  • 76 multiple-choice questions (must achieve score of 70% correct to pass)
  • 105 minutes to complete exam
  • Use exam ID A00-260; required when registering with Pearson VUE.

Exam topics include:

Overview
  • Define the architecture of the platform for SAS Business Analytics.
  • Describe the available interfaces.
  • Define the change management feature of SAS Data Integration Studio.
  • Discuss the DataFlux Data Integration Server.
Creating Metadata for Source and Target Data
  • 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.
Creating Metadata for Target Data and Jobs
  • Describe features of the New Table wizard.
  • Discuss SAS packages.
  • Discuss importing and exporting of relational metadata.
  • Discuss components of 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.
  • Import macro-based SAS code.
Working with Transformations
  • 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.
  • Use the Compare Tables transformation.
  • Discuss transformations in the SQL grouping of transformations.
  • Apply and use the Standardize with Definition transformation.
  • Discuss the SCD Type 1 Loader.
Working with Tables and the Table Loader Transformation
  • 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.
  • Discuss the Bulk Table Loader transformation.
  • Discuss components of the Join's Designer window.
Working with Slowly Changing Dimensions
  • 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.
Defining Generated Transformations
  • Define SAS code transformation templates.
  • Create a custom transformation
Deploying Jobs
  • Discuss the types of job deployment available for SAS Data Integration Studio Jobs.
  • Provide an overview of the scheduling process.
  • Discuss the types of scheduling servers.
  • Discuss the Schedule Manager in SAS Management Console.
  • Discuss batch servers.
  • Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.
  • Import SAS code.