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
- 10514 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rams
replacechr(0,reg_replace(input,'[^a-z A-Z]','/')'/',null)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the modules in Power Center
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is dynamic cache?
How many dimensions are there in informatica?
what are the deliverables?in your project?
What is the use of code page?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
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.
What is the difference between router and filter?
How to extract the informatica rejected data?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is DR strategy for Informatica project?
Reusable transformation and shortcut differences
What all join we can perform in LOOKUP transformation?
What are the different components of powercenter?
