This can be java heap issue. Try to increase it and see how that works.
I would try/check fields more than 4000 chars in length to 4000.
thanks for the reply.
We have increased the this option in Data relication task. but there is no change.
Do we need to configure any other property also.
That's what I was reffering to. You may go for more like 2048 .
Just in case try to unmap nvarchar fields from target and see how that works. I suspect issue is with more size fields.
We have to sync all the field from SalesForce to Sql server. We can not remove Varchar column.
Thanks, But it is taking more time after adding this property.
Property : OptimizeOracleSQLServerWrite='yes'
Does PK chunking makes any difference for this issue?