Skip Headers
Oracle® Fusion Middleware Knowledge Module Developer's Guide for Oracle Data Integrator
11
g
Release 1 (11.1.1)
Part Number E12645-03
Home
Book List
Master Index
Contact Us
Next
View PDF
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction to Knowledge Modules
1.1
What is a Knowledge Module?
1.2
Reverse-Engineering Knowledge Modules (RKM)
1.3
Check Knowledge Modules (CKM)
1.4
Loading Knowledge Modules (LKM)
1.5
Integration Knowledge Modules (IKM)
1.6
Journalizing Knowledge Modules (JKM)
1.7
Service Knowledge Modules (SKM)
1.8
Guidelines for Knowledge Module Developers
2
Introduction to the Substitution API
2.1
Introduction to the Substitution API
2.2
Using Substitution Methods
2.2.1
Generic Syntax
2.2.2
Specific Syntax for CKM
2.2.3
Using Flexfields
2.3
Using Substitution Methods in Actions
2.3.1
Action Lines Code
2.3.2
Action Calls Method
2.4
Working with Object Names
2.5
Working with Lists of Tables, Columns and Expressions
2.5.1
Using getTargetColList to create a table
2.5.2
Using getColList in an Insert values statement
2.5.3
Using getSrcTableList
2.6
Generating the Source Select Statement
2.7
Working with Datasets
2.8
Obtaining Other Information with the API
2.9
Advanced Techniques for Code Generation
3
Reverse-Engineering Strategies
3.1
Customized Reverse-Engineering Process
3.1.1
SNP_REV tables
3.1.2
Customized Reverse-Engineering Strategy
3.2
Case Studies
3.2.1
RKM Oracle
3.2.1.1
Reset SNP_REV Tables
3.2.1.2
Get Tables
3.2.1.3
Get views, partitions, columns, FK, Keys and other Oracle Metadata
3.2.1.4
Set Metadata
4
Data Integrity Strategies
4.1
Data Integrity Check Process
4.1.1
Check Knowledge Module Overview
4.1.2
Error Tables Structures
4.1.2.1
Error Table Structure
4.1.2.2
Summary Table Structure
4.2
Case Studies
4.2.1
Oracle CKM
4.2.1.1
Drop Check Table
4.2.1.2
Create Check Table
4.2.1.3
Create Error Table
4.2.1.4
Insert PK Errors
4.2.1.5
Delete Errors from Controlled Table
4.2.2
Dynamically Create Non-Existing References
4.2.2.1
Use Case
4.2.2.2
Discussion
4.2.2.3
Implementation Details
5
Loading Strategies
5.1
Loading Process
5.1.1
Loading Process Overview
5.1.2
Loading Table Structure
5.1.3
Loading Method
5.1.3.1
Loading Using the Agent
5.1.3.2
Loading File Using Loaders
5.1.3.3
Loading Using Unload/Load
5.1.3.4
Loading Using RDBMS-Specific Strategies
5.2
Case Studies
5.2.1
LKM SQL to SQL
5.2.1.1
Drop Work Table
5.2.1.2
Create Work Table
5.2.1.3
Load Data
5.2.1.4
Drop Work Table
6
Integration Strategies
6.1
Integration Process
6.1.1
Integration Process Overview
6.1.2
Integration Strategies
6.1.2.1
Strategies with Staging Area on the Target
6.1.2.2
Strategies with the Staging Area Different from the Target
6.2
Case Studies
6.2.1
Simple Replace or Append
6.2.1.1
Delete Target Table
6.2.1.2
Insert New Rows
6.2.2
Backup the Target Table Before Loading
6.2.2.1
Drop Backup Table
6.2.2.2
Create Backup Table
6.2.3
Tracking Records for Regulatory Compliance
6.2.3.1
Load Tracking Records
A
Substitution API Reference
A.1
Substitution Methods List
A.1.1
Global Methods
A.1.2
Journalizing Knowledge Modules
A.1.3
Loading Knowledge Modules
A.1.4
Check Knowledge Modules
A.1.5
Integration Knowledge Modules
A.1.6
Reverse-Engineering Knowledge Modules
A.1.7
Service Knowledge Modules
A.1.8
Actions
A.2
Substitution Methods Reference
A.2.1
getAK() Method
A.2.2
getAKColList() Method
A.2.3
getCatalogName() Method
A.2.4
getCatalogNameDefaultPSchema() Method
A.2.5
getCK() Method
A.2.6
getColDefaultValue() Method
A.2.7
getColList() Method
A.2.8
getColumn() Method
A.2.9
getContext() Method
A.2.10
getDataSet() Method
A.2.11
getDataSetCount() Method
A.2.12
getDataType() Method
A.2.13
getFilter() Method
A.2.14
getFilterList() Method
A.2.15
getFK() Method
A.2.16
getFKColList() Method
A.2.17
getFlexFieldValue() Method
A.2.18
getFrom() Method
A.2.19
getGrpBy() Method
A.2.20
getGrpByList() Method
A.2.21
getHaving() Method
A.2.22
getHavingList() Method
A.2.23
getIndex() Method
A.2.24
getIndexColList() Method
A.2.25
getInfo() Method
A.2.26
getJDBCConnection() Method
A.2.27
getJDBCConnectionFromLSchema() Method
A.2.28
getJoin() Method
A.2.29
getJoinList() Method
A.2.30
getJrnFilter() Method
A.2.31
getJrnInfo() Method
A.2.32
getLoadPlanInstance() Method
A.2.33
getModel() Method
A.2.34
getNbInsert(), getNbUpdate(), getNbDelete(), getNbErrors() and getNbRows() Methods
A.2.35
getNewColComment() Method
A.2.36
getNewTableComment() Method
A.2.37
getNotNullCol() Method
A.2.38
getObjectName() Method
A.2.39
getObjectNameDefaultPSchema() Method
A.2.40
getOption() Method
A.2.41
getPackage() Method
A.2.42
getParentLoadPlanStepInstance() Method
A.2.43
getPK() Method
A.2.44
getPKColList() Method
A.2.45
getPop() Method
A.2.46
getPrevStepLog() Method
A.2.47
getQuotedString() Method
A.2.48
getSchemaName() Method
A.2.49
getSchemaNameDefaultPSchema() Method
A.2.50
getSession() Method
A.2.51
getSessionVarList() Method
A.2.52
getSrcColList() Method
A.2.53
getSrcTablesList() Method
A.2.54
getStep() Method
A.2.55
getSubscriberList() Method
A.2.56
getSysDate() Method
A.2.57
getTable() Method
A.2.58
getTargetColList() Method
A.2.59
getTableName() Method
A.2.60
getTargetTable() Method
A.2.61
getTemporaryIndex() Method
A.2.62
getTemporaryIndexColList() Method
A.2.63
getUser() Method
A.2.64
hasPK() Method
A.2.65
isColAttrChanged() Method
A.2.66
nextAK() Method
A.2.67
nextCond() Method
A.2.68
nextFK() Method
A.2.69
setNbInsert(), setNbUpdate(), setNbDelete(), setNbErrors() and setNbRows() Methods
A.2.70
setTableName() Method
A.2.71
setTaskName() Method
B
SNP_REV Tables Reference
B.1
SNP_REV_SUB_MODEL
B.2
SNP_REV_TABLE
B.3
SNP_REV_COL
B.4
SNP_REV_KEY
B.5
SNP_REV_KEY_COL
B.6
SNP_REV_JOIN
B.7
SNP_REV_JOIN_COL
B.8
SNP_REV_COND
Scripting on this page enhances content navigation, but does not change the content in any way.