GoldenGate For BigData, Target Google BigQuery Table Getting Created With Schema Name
(Doc ID 2594647.1)
Last updated on OCTOBER 22, 2019
Applies to:Oracle GoldenGate Application Adapters - Version 12.3 and later
Information in this document applies to any platform.
Ct was trying to enable data replication from Oracle database to Google BigQuery, using Oracle GoldenGate for Big Data. They had following observed.
GG version: 126.96.36.199.1
Target side Big query table is getting created with the schema name appended with the table name.
For e.g., for the below table, target table is getting created with the name "sap_ecc_MARD_NEW"
MAP "PRODUSER"."MARD", TARGET "sap_ecc"."MARD_NEW";
A table with the same name exist in the Biquery dataset and its not getting used. Golden Gate is creating a new table instead, with the schema name appended.
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