How to read/retain the Western European characters(Windows-1252)
Our manufacturing client, uses an Informatica ETL tool to extract the data from the SQL Server through ODBC driver setting the IANAAppCodePage to "Western European (WIndows-1252)" and loads the data to Teradata DW. In this method, the extraction and loading of the data preserves the Windows-1252 characters. Data is perfectly matching when validated between these 2 systems.
I am trying to emulate the ETL functionality through Teradata PT by using the ODBC operator to connect & extract the data from SQL Server which uses the Progress Datadirect SQL Server Driver and loading to data to Teradata DW using Load Operator with the character set chosen to be the default for the network- attached client system.In this method, the some of the original Windows-1252 characters produced by the SQL Server is getting transformed/converted into an UTF-8 encoding and this method invalidates the data when tested between both the systems
Hence, we expect suggestions of the best method/option to be considered for this ETL functionality such that the original Windows-1252 characters are preserved through TPT.