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
- 7768 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
How many ways a relational source definition can be updated and what are they?
How we can create indexes after completing the load process?
Explain target update override in informatica
What is the difference between a connected look up and unconnected lookup?
How many ways are there to do 'remove duplicate records in informatica'?
How to configure mapping in informatica?
Informatica settings are available in which file?
What are the types of presistent cache in look up tr.
What is the format of informatica objects in a repository?
what is the complex transformation you used in informatica
State the differences between sql override and lookup override?
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.
if we have a delimiters at unwanted places in a flat file how can we over come those.
Define filter transformation?
How to create a non-reusable instance of reusable transformations?
