All Forums Viewpoint
hari428 1 post Joined 05/16
28 May 2016
data incorrect in one of column of my table

i have one table for of column for that table is 'rspn_answr_txt'.it is defind rspn_answr_txt VARCHAR(2000) CHARACTER SET LATIN NOT CASESPECIFIC.Due to this user is not getting vadlid data.he request to change it to  CHARACTER SET UNICODE.I have attched the values in the table fo that column.let me know what is the incorrect data in that column

gryback 271 posts Joined 12/08
07 Jun 2016

Not sure how this relates to Viewpoint ... seems more appropriate for a Teradata DB forum posting.

ahnajeeb 5 posts Joined 03/11
08 Jun 2016

It has nothing to do with Viewpoint.
How was the data laoded and what was the source . Can you compare the data against the source file or You should  ask the user " what is wrong with this data" What response he was expecting for  a particular row Vs the reported response?
Its hard to tell you what is wrong with this data -If you share "Expected" Vs "Actual" then  it wil lbe more clear.    
It could be Should not have NULLs , Numbers timestamps etc -  Does the user complained about Data / records is truncated ?  Wrong File is being loaded to table?  Some issue with Special Char etc .  Please get the specific concern . 


You must sign in to leave a comment.