.png){kind=logo}
Oracle Advanced Settings
-
DarkLight
Oracle Advanced Settings
-
DarkLight
Overview
In most cases, the advanced settings will not be required however Matillion CDC do provide some additional configuration items when setting up your pipelines. Please take a moment to understand what these advanced settings are and what they achieve before incorporating them within your pipeline.
Warning
If you are unclear about a particular setting, please reach out to Matillion for support.
Oracle Advanced Settings
Pipeline advanced settings can be added at the end of the Add Pipeline journey via the Matillion Data Loader UI.
snapshot.mode
The snapshot.mode setting allows control over the snapshot stage of the CDC process when your pipeline begins. Its valid values are listed below:
- initial: A snapshot is always captured if one does not previously exist. This is the default value.
- schema_only: Instead of running a data snapshot, the connector runs one of the schemas. When you simply need the changes made since the connector started—rather than a consistent snapshot of the data, this setting can be helpful.
Note
Note that this option is now available through a toggle in the Pipeline Settings UI when setting up your CDC Pipeline and should no longer be used as an Advanced Setting.
defaultRowPrefetch
The default number of rows to prefetch from the server. Default value is "10". When there are 1000 or more records in a table. Set 'defaultRowPrefetch' to 1000 in the advanced setting. As the defaultRowPrefetch which is 10, did not allows to retrieve all records ahead of the connection timing out.