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.
A column Status can contain Active or Inactive values. But the column values looks like,
Just updating my post. I fixed the issue by using ltrim and rtrim on all the string columns.
I am still unclear that this issue was casued by Informatica or by using TPT connection.