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