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
- 10892 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
Explain the types of lookup transformation?
What are mapplets?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can u any challenge your project?
draw informatica architecture 8.6 ?
What is a rank transform?
How to load data in informatica ?
How can we update a record in the target table without using update strategy?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the restrictions of union transformation?
What all are steps in up gradation of Informatica server?
Plz can any one say me how to get the informatica certification materials and dumps
What is the commit type if you have a transaction control transformation in the mapping?
What is union transformation in informatica?
What are the types of caches in lookup? Explain them.
