Skip navigation
Contact Us
616 Views 3 Replies Latest reply: Jan 24, 2013 4:09 PM by Info 2005 RSS
user ram Newbie 4 posts since
Jan 9, 2013
Currently Being Moderated

Jan 10, 2013 6:01 AM

load

My file has the below data

 

fursnishing`s design

 

but when i load using informatica it comes as below , please help on what are the changes need to be done before loading ?

 

fursnishing?s design

  • Venkat Byrapudi Master 916 posts since
    Mar 25, 2010
    Currently Being Moderated
    Jan 12, 2013 11:57 AM (in response to user ram)
    load

    Where u are loading database(which one) or File?

     

    Regards,

    Venkat

  • Antony Praveen Raj Newbie 6 posts since
    Jan 13, 2013
    Currently Being Moderated
    Jan 13, 2013 6:36 PM (in response to user ram)
    load

    If your source is a flat file then you need to edit the variable for code page in the .profile file in the unix server to get this issue resolved.

    • Info 2005 Novice 35 posts since
      May 16, 2012
      Currently Being Moderated
      Jan 24, 2013 4:09 PM (in response to Antony Praveen Raj)
      load

      try below options,

       

      option1-Make sure code page is same in all places(src,tgt connection,in DB,in server..etc)

       

      option 2-

       

      UPDATE TABLE SET FIELD = 

      CONVERT (FIELD,'utf8',  'WE8MSWIN1252' )

       

      Note :- This query will encode all the western European characters only to UTF-8.

More Like This

  • Retrieving data ...

Bookmarked By (0)