Interested to Buy Any Domain ? << Click Here >> for more details...
i have a flat file and the file s are like below
****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$
IN THIS FORMATE
Means un limited special charecter between and sides of the
string data..output should be(GANESH)
HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE
AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
- 6 Answers
- 11784 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / meenakshivc
Hi,
use this function for above question,
replacestr(0,col,'$','!','@','#','%','^','&','*', NULL)
or
replacechr(0,col,'$!@#%^&*', NULL)
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Does an informatica transformation support only aggregate expressions?
What is olap (on-line analytical processing?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do you mean by channel change?
What is the Process to creating lookup transformation in informatica
How to do unit testing in informatica? How to load data in informatica ?
Write the different tools in the workflow manager?
Explain about cumulative Sum or moving sum?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Different sorts of metadata that stores in the storage facility?
What is domain in terms of informatica?
Explain your project of banking domian.
What can we do to improve the performance of informatica aggregator transformation?
What is a filter transformation and why it is an active one?
