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
- 7964 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / masudul
Just pass the rows through an expression transformation.
then add a new port and write down the expression code-
substr(column_name, 1, (instr(column_name,'@')-1)).
See the output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How many ways a relational source definition can be updated and what are they?
Differentiate between Load Manager and DTM?
What is the fact table?
What is a repository? And how to add it in an informatica client?
How can we store previous session logs?
what is Active lock explain
What is native users?
Explain direct and indirect flat file loading (source file type) - informatica
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is SDLC way of code development?
What is a predefined event?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Is it possible to use a client with different version than that of its Informatica server?
differences between service based and product based?
What if the source is a flat-file?
