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 / manasa
please put down the replace command for the above question
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What you know about transaction control transformation?
What is a dimensional model?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is a standalone command task?
What is joiner transformation in informatica?
Can anyone tell me the new features in Informatica 9 Version?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Different qualification between a related rotate toward the sky and isolates look upward?
What are the data movement modes in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
scenario where i can use only concurrent execution of workflow.
Differentiate between source qualifier and filter transformation?
How to create a non-reusable instance of reusable transformations?
Which files are created during the session rums by informatics server?
4 yrs etl devloper roles and responsibilities?any body give solutions