Interested to Buy Any Domain ? << Click Here >> for more details...
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
- 3 Answers
- 7625 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
Hi,
You can achieve it easily in expression transformation by making an extra out port where you just need to specify
substr('ankit42',1,instr('ankit42','4')-1) logic.
but keep in mind that all of your source data must contains 42 as defined in your problem.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the advantage of informatica?
What is blocking transformation?
What is the difference between informatics 7x and 8x and what is latest version?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is INFORMATICA TESTING process
list out all the transformations which use cache?
Separate from a database, an information bazaar, and an information stockroom?
Is there any target staging area in informatica not staging area
Explain what are the different versions of informatica?
What is main use of mapplet?
How to Create a folder using pmrep command?
What is primary and backup node?
What are the new features of informatica 9.x at the developer level?
Explain the mapping variable usage example in informatica
