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.
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
What is informatica etl tool?
What is the function of look up transformation?
What are junk dimensions?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you update the records with or without using update strategy?
Explain the different lookup methods used in informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain lookup transformation in informatica
wat are deployement groups in informatica, how it will be used for developers
Differentiate between joiner and lookup transformation?
How can we handle two sessions in informatica?
How many input parameters can exist in an unconnected lookup?
What happens when a session fails and you click on recover?
define galaxy repository in informatica