Is it possible to marge two source tables to one table by GG?

Hi,

I was asked if it is possible to mart two tables by join/ union into one table by using oralce goldengate. Source and Target databases are both 19c (19.11) on OCI (DBCS), and using managed service of gg. In my opinion, this is not practically possible, but would like to make sure if my understanding is correct.

There are two scenarios:

1. union source tables A and B having the same table structure (the same format) to one target C table
2. join source tables A and B having the same primary keys but different columns to one target table C

In the first scenario, what we could do is to export both source tables A and B, and import to a target table C, and then setup the replicat to map the source tables to the one target table. This might work for insert, but suppose if a DML such as update and delete without predicates is executed in table A, the DML in the target table affects not only to the table A but B, and result in inconsistency.