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
- 9946 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
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explian the Process of deployment groups in informatica
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Differentiate between sessions and batches?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Is it possible to use a client with different version than that of its Informatica server?
Explain what transformation and how many are there in informatica?
differences between service based and product based?
What is standalone command task?
generate date / time dimension in informatica
Why union transformation is an active transformation?
What is depict expression change?
What are the transformations that are not supported in mapplet?
How are indexes created after completing the load process?
What are the main features of Oracle 8i with context to datawarehouse?
