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
- 7062 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 are the data movement modes in informatica?
What is the Process to creating lookup transformation in informatica
what is unit testing?tell me proceedure
What is sequence generator transformation in informatica?
What is the difference between stop and abort in informatica
What does reusable transformation mean?
How can we use batches?
How can we create index after completion of load process?
generate date / time dimension in informatica
wat are deployement groups in informatica, how it will be used for developers
What are the different versions of informatica?
What are ETL Tools?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How would you copy the content of one repository to another repository?
What are the performance considerations when working with aggregator transformation?
