Not sure if this helps but I wouldn't connect via Golden Gate. Instead I would connect directly.

Is the database instance on your localhost?

Without seeing DDL for the other table I would guess you have to join on ChangType as well.

Why not update directly from the view:

UPDATE mt
SET col1 = mv.col1
  , col2 = mv.col2 
FROM myView mv
JOIN myTable mt ON mv.PKID=mt.PKID;


No, That's how log shipping works. Maybe what you want is Replication.

To audit logins in SSMS right click the server and select properties on the security page select the option button to indicate your preference.

I was explaining the two different concepts from a T-SQL perspective, transactions and error handling. If I want to add an address for a new vendor only if i subsequently...

Transactions:

BEGIN TRAN

COMMIT TRAN /* ROLLBACK */

Error handling:

BEGIN TRY

END TRY
BEGIN CATCH

END CATCH

Used together:

BEGIN TRY

If the criteria for insert is differs from the update criteria you need to do an update then an insert, otherwise you can apply the criteria to the source using a subquery...

If you add a modifiedby column defaulted to suser() to your temporal table it will capture the login. Your application could override the default where authorization is controlled in the application. Changes outside the...

Can you post DDL, create table and inserts with sample data?