Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview

• Starting the Software
• Understanding the Client Workspace
  • Frame Functionality
  • Menus and Toolbars
  • DSA Menu and Toolbar Explained
    • File Menu
    • Edit Menu
    • View Menu
    • DSA Menu
    • Tools Menu
    • Help Menu
    • Keyboard Shortcuts
  • Task Panes
  • DSA Component Tree Pane
  • Graphical DSA Builder Pane
    • Context-Sensitive Menus
• Starting the Application Studio

2 DSA Basics

• Creating or Opening a DSA
• DSA Building Components
  • Processing Steps Folder
    • Core Processing Steps
    • Alternative Step Nodes
    • Sleep Step Nodes
  • Data Input Folder
    • Editing or Deleting an Input Node
  • Data Output Folder
    • Text Output Nodes
    • Editing a Text Output Step
    • Oracle DataLens Governance Studio Tab
    • DB Output Nodes
    • XML Update Nodes
  • Output Adapters Folder
    • DSL XML Nodes
    • DSL XML Structure Nodes
  • Pre-Post Processing Folder
    • Prerequisites Nodes
    • Pre/Post-Processing Nodes
    • Invalidate AM2 Cache and Mark AM2 Cache Complete Nodes
    • Sleep Nodes
• Putting It All Together
  • Example DSA

3 DSA Management

• Modifying Global Variables
• Modifying DSA Options
• Modifying Application Studio Options
• DSA Actions
  • Checking In a DSA
  • Checking Out a DSA
  • Validating a DSA
  • Testing a DSA
  • Checking Out DSA Packages
  • Checking In DSA Packages
  • Setting the Test Server
  • View My Tasks
    • Changing the Task Status
    • Creating a Task
  • Modifying the DSA Description

4 Transformation Map Builder

• Transformation Map Overview
  • Understanding the Transformation Map Client Workspace
    • Transformation Map Menu and Toolbar Explained
    • Map Component Tree Task Pane
    • Graphical Map Builder Task Pane
• Creating Transformation Maps
  • Database Query Data Input
  • XML Document Data Input
  • XML Document Update Data Input
• Transformation Map Builder Creation Components
  • Transformations Nodes and Widgets
    • Container Folders
    • Attributes& Fields Widgets
    • Process Control Widgets
    • Strings Widgets
    • Math Widgets
    • Exception Information Widgets
    • From Decision Map Widgets
    • Add-In Functions Widgets
  • New Input/Output Nodes
  • Database Updates Widgets
• Defining the Input Column
  • Adding Input Column Nodes
  • Creating Output Nodes from Input Nodes
• Defining the Transformation Column
  • Defining Lens Transforms
    • Operation Section
  • Defining Item Definition Transforms
    • Transform Options Tab
    • Standardized Outputs Tab
    • Classification Outputs Tab
    • Advanced Outputs Tab
    • Help Tab
    • Performance Options Tab
    • Resulting Data Output Format
  • Defining Web Service Transforms
  • Defining DB Transforms
    • Example Single-Field Database Transformation
    • Example Multiple-Field Database Transformation
• Defining the Output Column
  • Creating Item Definition Output Nodes
• Modifying Transformation Map Column Nodes
  • Moving Column Nodes
  • Editing Column Nodes
  • Disconnect Incoming
  • Deleting Nodes
• Transforming Data
  • Transforming Data Using Attributes and Fields
  • Transforming Data Using Processing Controls
  • Transforming Data Using String Operations
    • Literal String Operation
    • Substring Operation
    • Logical Replace Input Operation
    • Concatenate Inputs Operation
    • Extract, Splitter and Split Field Inputs Operation
  • Transforming Data Using Math Operations
• Testing and Validating Transformation Maps
  • Testing a Map
  • Validating a Map
• Importing and Exporting Maps
• Map Options
  • Text Input Map Options
  • Database Map Options
  • XML Map Options

5 Decision Map Builder

• Decision Map Example
• Creating Decision Maps
  • Creating Decision Maps Using Lens Transformations
  • Creating Decision Maps Using Item Definition Transformations
• Navigating Decision Maps
  • Decision Map Example
• Decision Map Options

6 Advanced Mapping and DSA Concepts

• Defining Multiple Classification Transformation Maps
• Using De-Duplicate
• Matching Attributes
  • Attribute Function Data Recognition and Matching
    • Attributes for Recognition
    • Attributes for Matching
    • Components of a Matching Application
  • Using Semantic Key1 for Matching
    • Step 1: Creating an Attribute Cache (Semantic Key Cache) DSA
    • Step 2: Creating an Attribute Matching Application Using the Attribute Cache
  • Using Semantic Key2 for Matching
• Finding Attributes
• Matching Ngrams
  • Step 1: Creating an Ngram Cache that Includes a Set of Unique Ngrams with Frequencies
    • Name Field
    • Locale List
    • Type of Ngram Check Boxes
    • Create Bi and Tri-grams alphabetically Check Box
    • Lowercase the Ngram Check Box
    • Truncated Rsindex
    • Insert Section
  • Step 2: Process a Set of Records Against the Ngram Index to Determine Matches
    • General Tab
    • Exact Query Tab
    • Fuzzy Query Tab
    • Update Tab
• Using the Create Table Widget
• Using Secondary DSAs
  • Using the Apply DSA Option
  • Using the Re-Run DSA Option
  • Using the Quick Lookup DSA Option
  • Using the Completion DSA Option
• Using Stored Database Procedures and Functions
  • Using Stored Functions
  • Using Stored Procedures
  • Transaction Handling

A Installing the Client Software

B Regular Expressions

• Special Characters in Regular Expressions
• Useful Regular Expressions in Terminology Rules