If column name in the target is different than the source, You can configure this with APPLY_COLUMN_NAMES_MAP parameter of Dbvisit Replicate.

Syntax:

 

set *.APPLY_COLUMN_NAMES_MAP coumn1=newcolumn1[, column2=newcolumn2]

Example:

 

set *.APPLY_COLUMN_NAMES_MAP empno=employee_no

APPLY process requires a restart to implement this mapping.

After restart, APPLY process log will show column mapping details as follow.

013/05/03 05:34:37 INFO> Column translate: [empno]=>[employee_no]