DSXchange

Good morning guys,

I am transfering data from ODBC stage to Oracle stage both source and target columns are varchar2 datatype.In one of the column I am getting trailing spaces.i used trim function to remove those spaces butit didn't work.I am thinking those are not spaces may be tab or some other characters.When I ran the query in the toad it is showing boxes symbol at the end.

Could you please help me on how to remove trailing characters.

Regards
Narasa

A box character huh. See if the following works for you Test it out with the above command. If it works then make sure you dont have any dots in your data before accepting it as a solution.

You need to find out what the characters are, obviously they're not spaces. Dump to a flat file and then use a hex editor to examine the file.

Looks like u have nulls padded....nulltoempty function should help you out