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.
- 1 Answers
- 3728 Views
- CTS, I also Faced
- E-Mail Answers
Answer / aa
Use reg_replace
reference
https://etltechsolutions.wordpress.com/
| Is This Answer Correct ? | 2 Yes | 0 No |
What is exclusive and normal mode for repository services?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
What is meant by LDAP users?
Briefly describe lookup transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
why we use materialized view over view?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
what is the method of error handling when session is running?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what is lookupoverriding?
Teradata 
