Hi, I would like to insert a new record into target table after an update only on source table, kind of like an update trigger inserting a record into new table but in goldengate terms. I tried FORUPDATE but it didn't work. Can someone please point me to the right syntax ... ? Thanks.
Sounds like you want a dual mapping with default behavior on the first and convert updates to inserts on the second. Here's one way to do it:
Map S.T1, Target T.T1;
Map S.T1, Target T.NEWTABLE, INSERTALLRECORDS;