Data Overlapping in table while using TPT connection

Hi,

I am using Informatica 8.6 and TPT connection to write data into the target table. The stage table loads fine without any issue. Using the same kind of TPT connection, I read from stage and write it into Target table.

But the data starts to overlap into another column.

For eg,

A column Status can contain Active or Inactive values. But the column values looks like,

Active -- correct

Activev -- incorrect

Active: -- incorrect

Activeve -- incorrect looks like the word Inactive is overwritten by Active

Activea/2077 23:59:59.000000 -- incorrect. suffixed the next date column (no clue on how the a came !)

the column order is

id , status, date time created_by

Not only this column most of the columns are corrupted like that, for another column id

9-AVCD-204hangp the character hangp is my partial user id getting suffixed to this column. (jumped 1 column to get the value)

This clearly shows that the data of the next column is being appended to this column.

Also noted that the next column data looks good. There is no overlapping. Then randomly it starts(no sequence / pattern).

Can anyone tell why this is happening ? and how to resovle this problem ?