We have Oracle as both source and target.
For oracle Data replication allows only Full data load. So we tried for some tables suing data replication.
This wizard creates target table also. In source it has Varchar2 datatype, but in target it is converting it into nvarchar, due to which some data is getting truncated.
Any ways to specify that varchar should be varchar only in target table.
Any help regarding this would be helpful.
Retrieving data ...