DSXchange

Hi Guys,
Good morning.
I am getting data truncation problem.In the source Oracle table column defined as a long varchar but when i used it as varchar in datastage with max length it is telling data truncated.
Please advice me how to handle long varchar data.
Thanks in advance
Reddy

Mr Reddy,
Why don't you try LongVarChar in DS? Hope this can solve your problem.

What is your target. WHat the length in your source and target?

Thanks for your quick responses.
Source and target both are Oracle.
In the source for a particular column they defined it as long varchar but when i used same matadata i am getting "OCI_INVALID_HANDLE" error but when i changed the column data type to varchar data truncation problem happening.

Please advice me.

Thanks
Narasa

I want to know the length number of the source and target. Obviously your target length is smaller than your source. You need to either handle that or ask your dba to increase the length of that particular column.