How to Override Default Target Schema in Replication
Scenario
HVR creates the target table in the destination DBMS user’s default schema. It can happen that users want to override this default schema due to security or architectural reasons.
Steps
To change the target schema, add a new /TableProperties action to the channel as in the image below:
Existing integrate and refresh jobs should be recreated with Initialize and Refresh after this change.