Loading Knowledge Modules (LKM) Notes

• Loading Process Overview
• Loading Table Structure
• Loading Method

The loading method is the key to optimal performance when loading data from a source to the staging area. There are several loading methods, which can be grouped in the following categories:

• Loading Using the Agent
• Loading File Using Loaders
• Loading Using Unload/Load
• Loading Using RDBMS-Specific Strategies
• LKM SQL to SQL
• Drop Work Table
• Create Work Table
• Load Data
• Drop Work Table