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
- 11858 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / anirban_ghosh
Since it's been said...we know nothing of the special characters present in between...therefore..the wise thing would be tp extract each character and compare it with the (int value) of the alphabets......if the (int) value of the extracted character is between....65-90 or 97-122......store it in a queue......at the end....flush out the queue....that's it!!!
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is olap (on-line analytical processing?
How to go to the older version for a mapping?
What is a filter transformation and why it is an active one?
What are active and passive transformations?
How can a transformation be made reusable?
Can informatica load heterogeneous targets from heterogeneous sources?
What is target designer and target load order?
How can you increase the performance in joiner transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is difference between a gateway node and worker node?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How many number of sessions can one group in batches?
How to elaborate tracing level?
What are the limitations of joiner transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
