Load tables are the first entry point for all information coming into the data warehouse. There are multiple ways of getting data into Load tables.
Load Type | Description |
|---|---|
Database Link Load | The data is loaded from another database |
External Load | The Load table is populated by some external process, e.g. an ETL (Extract, Transform and Load) tool or EAI (Enterprise Application Integration) tool, putting the data directly into the Load tables. |
ODBC Load | The data is loaded via an ODBC connection, either directly by reading and inserting each row (a Load Type of ODBC load), or via a file by reading from the source system using ODBC and writing to a file and then loading the file (a Load Type of Native ODBC). ODBC connections require a Windows scheduler. |
File Load | A flat file load where most of the processing is managed and controlled by the scheduler. |
Script-based load | A flat file load where a host system, e.g. UNIX or Windows script file is executed to perform the load. Script-based loads on Windows support both DOS Batch and PowerShell scripts. |
XML File load | This method loads an XML file from a Windows directory. |
A Windows scheduler must be available to handle ODBC-based loads. Refer to Tools > Options > Available Load Types for details.