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
- 7777 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
What are the uses of etl tools?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is substr in informatica?
What is target designer and target load order?
How can we store previous session logs?
draw informatica architecture 8.6 ?
How to extract sap data using informatica?
How can you increase the performance in joiner transformation?
What is the cumulative sum and moving sum?
How can we update a record in the target table without using update strategy?
Parameter and variable differences
What is a standalone command task?
How are indexes created after completing the load process?
define galaxy repository in informatica
tell me about your project functionality
