Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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.



How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tool..

Answer / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,


What is the benefit of partitioning a session?

0 Answers  


Why we use lookup transformations?

1 Answers  


How to create Target definition for flat files?

0 Answers   Informatica,


my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,


In joiner, how to load Master table in Target?

2 Answers  


suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,


what is confirmed dimension?

6 Answers  


Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,


Explain scd type 3 through mapping.

0 Answers  


what is difference between dimention table and fact table?

1 Answers  


My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,


Categories