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
- 11783 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
Explain the etl program with few examples.
What is meant by query override?
Write the unconnected lookup syntax and how to return more than one column.
Explain target update override in informatica
What is the sequence generator transformation in informatica?
While migrating the data from one environment to another environment how would you manage the connections?
Enlist the various types of transformations.
What is rank transform?
Is it possible to define a single node as a Gateway node as well as worker node?
What do you mean incremental aggregation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the types of lookup transformation?
How you can differentiate between connected lookup and unconnected lookup?
What is the format of informatica objects in a repository?
According to his methodology what all you need before you build a datawarehouse
