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
- 11979 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
What is Data Caches size?
What is union transformation in informatica?
What are different types of transformations available in informatica?
If informatica has its scheduler why using third party scheduler?
What is native users?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to generate sequence numbers using expression transformation?
How to handle decimal places while importing a flatfile into informatica?
Differentiate between router and filter transformation?
Global and Local shortcuts. Advantages.
Which means the first record should come as last record and last record should come as first record and load into the target file?
design of staging area?
What are batches?
What are the types of data warehouses?
What is the difference between a repository server and a powerhouse?
