We are replicating Oracle to Snowflake and have cases where Oracle tables are loaded using EXCHANGE PARTITION.
GoldenGate doesn't support DDL for Snowflake as a target, and additionally Snowflake doesn't support EXCHANGE PARTITION.
I was wondering if there might be a way to get around this. For example, replicating the initial table from Oracle to Snowflake, and then capturing the ALTER TABLE EXCHANGE PARTITION ddl command but map it to a stored procedure on Snowflake which performs an ALTER TABLE SWAP WITH command instead?