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
- 12184 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / hari
We can use reg_match function in informatica with required
regular expression to allow the charchters and number
format u need . In this way we can easily restrict any
special charchter.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
What is union transformation in informatica?
What is a router transformation?
What is a joiner transformation?
how we can load rejected record's at run time?(not through bad files)
wat are deployement groups in informatica, how it will be used for developers
How to create a non-reusable instance of reusable transformations?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the prerequisite tasks to achieve the session partition?
What is olap (on-line analytical processing?
What is intricate mapping?
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?
Global and Local shortcuts. Advantages.
To import the flat file definition into the designer where should the flat file be placed?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
