Truncation of Data
Posted: Tue Jan 30, 2007 4:41 pm
Hi,
I have a simple job of copying data one table in one Database to another table in other database. But when I trying to copy the data using Parallel Extender job it is truncating the last digit in the column even though the Column is defined as varchar. I had tried increasing the length of the column and also trim but it didn't work . So I had done a Server job of the same data dump and it is working fine. So can some one explain to me why the data is being truncated by the PX job. I am using DRS stage to dump the data since the respective databases are sitting on MSSQL servers.
The column in question has data as 1000, Z123 etc.,
Thanks.
I have a simple job of copying data one table in one Database to another table in other database. But when I trying to copy the data using Parallel Extender job it is truncating the last digit in the column even though the Column is defined as varchar. I had tried increasing the length of the column and also trim but it didn't work . So I had done a Server job of the same data dump and it is working fine. So can some one explain to me why the data is being truncated by the PX job. I am using DRS stage to dump the data since the respective databases are sitting on MSSQL servers.
The column in question has data as 1000, Z123 etc.,
Thanks.