OGGBD- Partitioned Data In Monthly Folders using gg.handler.filewriter.partitioner
(Doc ID 2883959.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate Big Data and Application Adapters - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Goal
The source table is partitioned by month and would like to place these monthly partitioned data in S3 in its monthly folder using OGG Big Data
Used
gg.handler.filewriter.partitioner.<Table Name>=<prefix name>=${columnValue[<column name>]}
It is creating but not as desired.
for ex:
<prefix name>=2014-01-31 22:56:14.227000000
<prefix name>=2014-01-31 22:56:16.478000000
How we can put the folders be like yearly then monthly
<path>/2021
01
02
03
04
05
06
07
08
09
10
11
12
<path>/2022
01
02
--
--
Solution
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
| Goal |
| Solution |