Oracle GoldenGate uses COLMAP to specify mapping in replicat configuration. Also it is possible to execute stored procedures using SQLEXEC clause - this way you can implement your mapping inside your stored procedure. My question is - is it possible to completely replace built-in GG mechanism for target records insert/update with custom stored procedure wich takes care of both mapping and serialization logic? Something like
MAP TEST_TAB1, TARGET TEST_TAB1, SQLEXEC (
PARAMS(c1=COL2, c2=COL2, c3=COL3)),
NOCOLMAP -- !!!
MAP TEST_TAB1, SQLEXEC ( -- no TARGET !!!
PARAMS(c1=COL2, c2=COL2, c3=COL3))
the idea is - GG should execute the procedure for each input record and does nothing else. The reason for custom implementation is a complexity of record mappings - we need to map several input records into one aggregated target record. Basically GG would provide data feed only.