SAS® Certified Data Integration Developer for SAS® 9 — Information & Free Practice

The authority publishes percentage ranges for each content area. The practice percentages below use the midpoint of each range, normalized to 100%; they are not exact percentages published by the authority. Practice question counts may differ slightly because of rounding.

• Overview — Official range: 5–6% (Practice allocation: 5.5%)

  • Platform architecture for SAS Business Analytics
  • SAS Data Integration Studio interface
  • Change management
• Creating Metadata for Source and Target Data — Official range: 19–20% (Practice allocation: 19.5%)

  • Administrative tasks
  • New Library Wizard
  • Register Tables wizard and source metadata
  • Microsoft Access table metadata using ODBC
  • Comma-delimited external file metadata
  • Import and Export Metadata
• Creating Metadata for Target Data and Jobs — Official range: 17–18% (Practice allocation: 17.5%)

  • New Table wizard
  • Join's Designer window
  • Mapping and propagation
  • Performance statistics
  • Metadata reports for tables and jobs
  • Impact and Reverse Impact Analysis
• Working with Transformations — Official range: 21–22% (Practice allocation: 21.5%)

  • Extract and Summary Statistics transformation
  • Loop transformations
  • Status handling
  • Data Validation transformation
  • Rank, Transpose, Append, List and Sort transformations
  • SQL grouping transformations
• Working with Tables and the Table Loader Transformation — Official range: 17–18% (Practice allocation: 17.5%)

  • Reasons to use Table Loader
  • Table Loader load styles
  • Types and definition of keys
  • Definition of indexes
  • Table Loader options for keys and indexes
  • Bulk Table Loader transformation
  • Join’s Designer Window for in database processing
• Defining Generated Transformations — Official range: 5–6% (Practice allocation: 5.5%)

  • SAS code transformation templates
  • Custom transformation
• Deploying Jobs — Official range: 5–6% (Practice allocation: 5.5%)

  • Types of job deployment
  • Scheduling process
• In Database Processing — Official range: 7–8% (Practice allocation: 7.5%)

  • In-database processing and benefits
  • Enable in-database processing
  • ELT methods
  • DBMS functions in a SAS DI job