Skip Headers
Oracle® Enterprise Data Quality for Product Data Application Studio Reference Guide
Release 11
g
R1 (11.1.1.6)
Part Number E29128-03
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
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 DSA Variables
Modifying DSA Options
Modifying Application Studio Options
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
Modifying the DSA Description
Creating or Editing a Data Lens Group
View My Tasks
Changing the Task Status
Creating a Task
Viewing Data Enrichment Tasks
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 Map
s
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
Help Tab
Advanced Outputs 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
Components of a Matching Application
Attributes for Recognition
Attributes for Matching
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
Using Global Transform Maps
Using StatSim Indexes
Step 1: Creating the StatSim Index Creation DSA
Step 2: Creating the StatSim Matching DSA
A
Regular Expressions
Special Characters in Regular Expressions
Useful Regular Expressions in Terminology Rules