Skip Headers
Oracle® Health Sciences Clinical Development Analytics Administrator's Guide
Release 2.2 for Standard Configuration
E25023-03
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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.1.2
Oracle Health Sciences Clinical Development Analytics Hierarchy
2.2
Executing the ETL Execution Plans
2.3
Customizing an ETL Execution Plan
2.4
Creating an ETL Execution Plan
2.5
Modifying an ETL Execution Plan
2.6
Scheduling an ETL Execution 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
Informatica Mappings used in Multi-Source Integration
A
Troubleshooting
A.1
Oracle Business Intelligence Data Warehouse Administration Console Task Fails due to Missing Parameter File
A.2
Sorting and Displaying of Null Values in Reports
A.3
Aborting a Workflow
Glossary
Index