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
Data Truncation problem
Moderators: chulett, rschirm, roy
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
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