Skip Headers
Oracle® Health Sciences Clinical Development Analytics Administrator's Guide
Release 3.1.1 for Standard Configuration
E63311-01
Contact Us
Next
PDF
·
Mobi
·
ePub
1/9
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Documentation on Oracle Technology Network
Related Documents
Conventions
1
Maintaining the OBIEE Repository and Warehouse
1.1
Maintaining the Oracle Health Sciences Clinical Development Analytics OBIEE Repository
1.1.1
Modifying the Repository
1.1.1.1
Details for Selected Modifications
1.1.2
Merging Changes into a New Oracle-supplied Repository
1.2
Maintaining the Oracle Health Sciences Clinical Development Analytics Data Warehouse
1.2.1
Extensions
1.2.2
Substitutions
1.2.3
Modifying Data Warehouse Tables
1.3
Derivations
2
Extract Transform Load Programs
2.1
ETL Architecture
2.1.1
Adding a New Data Source
2.2
Executing the ETL Load Plans
2.2.1
Executing CDA - Complete Initial De Dup Load Plan
2.2.2
Executing CDA - Complete Warehouse with Dedup Load Plan
2.2.3
Executing CDA - Inform Automerge Load Plan
2.3
Customizing an ETL Load Plan
2.4
Creating an ETL Load Plan
2.5
Modifying an ETL Load Plan
2.6
Scheduling an ETL Load Plan
3
Multi-Source Integration
3.1
Overview
3.1.1
Foreign Key Adjustment
3.1.2
Unit of Work
3.1.3
Necessity of Deduplication
3.1.4
Coordinated Dimensions
3.1.5
Layering and Options
3.1.5.1
Oracle Clinical Data Analytics and Oracle Healthcare Master Person Index
3.1.6
Intersection of Deduplication Paths
3.1.7
Initial Load and Incremental Load
3.1.8
Oracle Healthcare Master Person Index Deduplication Process
3.1.8.1
Match Engine and Master Index
3.1.8.2
Matching Rules Using Project Configuration
3.1.9
Components of the Deduplication Path
3.1.9.1
Bulk Extracting, Cleansing, and Loading
3.1.9.2
Extractor
3.1.9.3
Deduplication Program
3.1.9.4
Matching Rules Specification
3.1.9.5
Data Stewardship
3.1.9.6
Master Index
3.1.9.7
Dimension MDM SDE
3.1.9.8
Persistent Master Staging Table
3.2
Preliminaries to Using Oracle Healthcare Master Person Index Deduplication Projects
3.2.1
Installation Results
3.2.2
Oracle Healthcare Master Person Index File Structure
3.3
Processes for Using Oracle Healthcare Master Person Index Deduplication Projects
3.3.1
Adding Sources to the Project
3.3.2
Adjusting Project Configuration
3.3.3
Promoting an Attribute to Being a Match Field
3.3.4
Preparing the Master Index Database Schema
3.3.5
Generating and Deploying the Master Data Index Manager Application
3.3.6
Initial Load Processes
3.3.6.1
Extract
3.3.6.2
Profile
3.3.6.3
Cleanse
3.3.6.4
Running Bulk Match in Analysis Mode and Adjusting Match Rules
3.3.6.5
Bulk Load
3.3.7
Incremental Load Processes
3.3.7.1
Using MIDM Steward Loaded Data
3.4
Handling Fact Data after Dimension Deduplication
3.4.1
Merged Fact Records Consequent to LOV Dimension Merge
3.4.2
General Case: Discovered Duplicate Fact Records
3.4.2.1
Impact of Dimension Deduplication on Fact and Target Tables
3.5
Rules and Recommendations
3.5.1
Rules
3.5.2
Recommendations
3.6
Oracle Health Sciences Clinical Development Analytics' Match Rules
3.6.1
Policies for Creating Shipped Match Rules
3.6.2
Configurations
3.7
User-supplied Deduplication System
3.8
Extending the Warehouse
3.8.1
Adding a Column to the Persistent Staging Table
3.9
ODI Mappings used in Multi-Source Integration
A
Troubleshooting
A.1
Sorting and Displaying of Null Values in Reports
A.2
Aborting a Load Plan