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
- 10515 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ratalarayudu
hi,
By using replacechr function we can remove unwanted characters .
Regards,
Rayudu.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Differentiate between router and filter transformation?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is decode in informatica?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Design time, run time. If you don't create parameter what will happen
What are the designer tools for creating transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the modules in Power Center
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What are the differences between oltp and olap?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are active and passive transformations?
What is main use of mapplet?
What are the popular informatica products?
