Summary of Extract Parameters
The Extract process captures either full data records or transactional data changes, depending on configuration parameters, and then sends the data to a target system to be applied to target tables or processed further by another process, such as a load utility.
Table 2-2 Extract Parameters: General
Parameter | Description |
---|---|
Controls the number of discarded records after which Extract aborts. |
|
Adjusts timestamps of records transferred to other systems when those systems reflect different times. |
|
Controls whether before and after images are stored in one trail record or two. |
Table 2-3 Extract Parameters: Processing Method
Parameter | Description |
---|---|
Defines an Extract group as an online process. |
|
Extracts entire records from source tables. |
Table 2-4 Extract Parameters: Selecting, Converting, and Mapping Data
Parameter | Description |
---|---|
Controls whether Oracle GoldenGate writes only the key or all columns to the trail for delete operations. |
|
Causes only primary key columns and changed columns to be logged for updates. |
|
EXCLUDEHIDDENCOLUMNS |
The parameter disables all the Oracle Database hidden columns including the timestamp columns created using automatic CDR. |
Specifies Replicat or data pump changes to be excluded from trail files. |
|
Controls certain aspects of the way that Oracle GoldenGate fetches data. |
|
Logs the columns that are required to support Conflict Detection and Resolution and Integrated Replicat. |
|
Specifies sequences for synchronization. |
|
Specifies tables for extraction and controls column mapping and conversion. |
|
Excludes source tables from the extraction process. |
|
Specifies a file containing target table definitions for target databases that reside on the NonStop platform. |
|
Specifies the ASCII character set for data captured from DB2 on z/OS, when both ASCII and EBCDIC tables are present. |
|
Specifies the EBCDIC character set for data captured from DB2 on z/OS, when both ASCII and EBCDIC tables are present. |
Table 2-5 Extract Parameters: Routing Data
Parameter | Description |
---|---|
Specifies an extract file to which extracted data is written on the local system. |
|
Specifies a trail to which extracted data is written on the local system. |
|
Specifies an extract file to which extracted data is written on a remote system. |
Table 2-6 Extract Parameters: Tuning
Parameter | Description |
---|---|
Controls the Bounded Recovery feature of Extract. |
|
Controls the virtual memory cache manager. |
|
Determines the amount of time that record data remains buffered before being written to the trail. |
|
Supplies capture processing options. |
|
Defines a long-running transaction and controls the frequency of checking for and reporting them. |
Table 2-7 Extract Parameters: Maintenance
Parameter | Description |
---|---|
Specifies the way that trail files are aged. |
Table 2-8 Extract Parameters: Security
Parameter | Description |
---|---|
Required to decrypt data on the target server. |
|
Controls encryption of data in a trail or Extract file. |