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...
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 are the different versions of informatica?
Briefly describe lookup transformation?
what is song in infrmatica...?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the different kinds of facts.
What do you mean by enterprise data warehousing?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
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
What is enterprise data warehousing?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How to create Target definition for flat files?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is a mapplet/worklet in informatica?