- Posted by Gavin Soorma
- On April 12, 2011
- 2 Comments
- colmap, getval, params, sqlexec
Let us see how we can use the SQLEXEC parameter of GoldenGate to execute both an SQL query as well as a stored procedure and then using the @GETVAL function, we can populate a column in the target database which is not present on the source table.
Using a simple