modify stage truncate my string

bagus · Post by **bagus** » Tue Feb 08, 2011 2:17 am

Hi all,
i have a strange problem. i try to drop columns using modify stage. but strangely one of the varchar column i keep losing it values from 160 character to 100. like somebody put substring[0,100] to that column, only it isn't. anyone experience the same thing ?

priyadharsini · Post by **priyadharsini** » Tue Feb 08, 2011 2:47 am

check the length of that column in the modify stage output link.

bagus · Post by **bagus** » Tue Feb 08, 2011 2:52 am

checked, same 160 nullable varchar

bagus · Post by **bagus** » Tue Feb 08, 2011 3:32 am

solved by explicitly declaring the column is 160 character in specification. thanks.