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
- 11986 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / meenakshivc
Hi,
use this function for above question,
replacestr(0,col,'$','!','@','#','%','^','&','*', NULL)
or
replacechr(0,col,'$!@#%^&*', NULL)
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we create index after completion of load process?
How to configure mapping in informatica?
What is deployment group?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are the differences between oltp and olap?
Define update strategy?
What is domain in terms of informatica?
What are data-driven sessions?
Explain the different kinds of facts.
How can we use mapping variables in informatica? Where do we use them?
What does “tail –f” command do and what is its use as an Informatica admin.
Informatica settings are available in which file?
In informatics server which files are created during the session rums?
