OWB 22.214.171.124 New Feature - Preprocessor in External Table
(Doc ID 1347541.1)
Last updated on MAY 05, 2017
Applies to:Oracle Warehouse Builder - Version 126.96.36.199 and later
Information in this document applies to any platform.
This document describes the new OWB 188.8.131.52 feature for External Tables: it is about enhancing External Table support in Oracle Warehouse Builder so as to support the use of preprocessor in External Table.
An External Table is a table whose metadata is stored in the database but whose data is stored in files outside the database. The database uses the metadata describing external tables to expose their data as if they were relational tables.
External tables can be preprocessed by user-supplied preprocessor programs. By using a preprocessing program, users can use data from a file that is not in a format supported by the driver. For example, a user may want to access data stored in a compressed format. Specifying a decompression program for the ORACLE_LOADER access driver allows the data to be decompressed as the access driver processes the data.
OWB 184.108.40.206 and higher
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document