hi all,
i have a problem in loading data into the vertica database with informatica tool.
i have some special charecters in sql server in description and subject columns. data type for these columns are nvarchar.
data presents in sql server is like this
"Sehr geehrte Damen un Herren,
hiermit bestätige ich die Richtigkeit meiner Adressinformationen und die
meines Gerätes. Ich bitte Sie wir besprochen den Austausch zum 15.04.2013
vorzunehmen.
Mit freundlichen Grüßen
Christin Röseler"
and data loaded into the target as like this
"Sehr geehrte Damen un Herren,
hiermit best�tige ich die Richtigkeit meiner Adressinformationen und die
meines Ger�tes. Ich bitte Sie wir besprochen den Austausch zum 15.04.2013
vorzunehmen.
Mit freundlichen Gr��en
Christin R�seler".
i have problem like this in loading data. target table datatype is varchar.
can anybody help me to solve this problem to load exact data which is available in source to target.
thanks in advance.
bhupal
how to load special charecters into vertica database
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: how to load special charecters into vertica database
Hi,
How are you extracting the data from SQL Server? What tool are you using? Are you extracting to a flat file?
Maybe the following topic can help out?
viewtopic.php?f=3&t=1030
Thanks!
How are you extracting the data from SQL Server? What tool are you using? Are you extracting to a flat file?
Maybe the following topic can help out?
viewtopic.php?f=3&t=1030
Thanks!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.