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
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 are the data movement modes in informatica?
How we can create indexes after completing the load process?
What is the procedure for creating independent data marts from informatica 7.1?
Is there any target staging area in informatica not staging area
What is meant by target load plan?
If informatica has its scheduler why using third party scheduler?
What is lookup transformation?
What is a filter transformation?
How to do unit testing in informatica? How to load data in informatica ?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Whats the difference between informatica powercenter server, repositoryserver and repository?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
how to load dimension table and fact table. plz tell me the steps.
Explain about Informatica server process that how it works relates to mapping variables?
What is the difference between router and filter?