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
- 11863 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ratalarayudu
hi,
By using replacechr function we can remove unwanted characters .
Regards,
Rayudu.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do you take back up of repository?
How many dimensions are there in informatica?
What is meant by LDAP users?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what is size of u r database?
How are the sources and targets definitions imported in informatica designer?
can we override a native sql query within informatica? How do we do it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the difference between informatics 7x and 8x and what is latest version?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Briefly define a session task?
What is meant by pre and post session shell command?
Write the program through which the records can be updated?
How we can create indexes after completing the load process?
