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
- 11993 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 xml source qualifier transformation in informatica?
what is the complex transformation you used in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is an aggregator transformation?
What is aggregator transformation in informatica?
What is meant by target load plan?
Enlist the differences between database and data warehouse.
Differentiate between joiner and lookup transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Explain what are the different types of transformation available in informatica.
Define update strategy?
What will be the approach?
Define pmcmd command?
Where is metadata stored?
what are the deliverables?in your project?
