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
- 7804 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / nsatyabrat7
use expression transformation and create a output port and use replacechr function.
replacechr(1,name,'@gmail.com',null) and connect the output port to target.
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is intricate mapping?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to call shell scripts from informatica?
How many dimensions are there in informatica?
What is an Integration service in Informatica?
How an expression transformation differs from aggregator transformation?
Which are the different editions of informatica powercenter that are available?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How is union transformation utilized?
What is aggregate cache in aggregator transformation?
What are ETL Tools?
How to handle decimal places while importing a flatfile into informatica?
Is there any target staging area in informatica not staging area
How would you join a node to the already existing domain?
What is sorter transformation?
