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
server hot-ws270 is connect to Repository B. What does it mean?
EXL informatica Questions
How to elaborate powercenter integration service?
What is dimensional table?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Is it possible to use a client with different version than that of its Informatica server?
Please let me know how to make Data masking in informatica..
Describe the impact of several join conditions and join order in a joiner transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the function of union transformation?
how to load rows into fact table in data warehouse
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is meant by pre and post session shell command?