Use reg_replace reference https://etltechsolutions.wordpress.com/

How to get rid of non ascii characters in a string?
Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件

to

United States Microsoft Visual Studio Tools for Applications 2012 x86.

Question Posted / aa

1 Answers
3713 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is fact table? Explain the different kinds of facts.

1076

generate date / time dimension in informatica

1125

How we can create indexes after completing the load process?

1160

Explain pmcmd command usage in informatica

1131

wat are deployement groups in informatica, how it will be used for developers

1719

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2065

What is meant by LDAP users?

1208

r u done any partitions in ur project?

1827

How to convert multiple rows to single row (multiple columns) in informatica

1378

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

How do you load only null records into target? Explain through mapping flow.

2022

How we can use union transformation?

1051

What the difference is between a database, a data warehouse and a data mart?

1154

What is intricate mapping?

1202

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866