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
- 7772 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 various types of transformation?
What are mapplets? How is it different from a Reusable Transformation?
Briefly explain the aggregator transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
While migrating the data from one environment to another environment how would you manage the connections?
Explain informatica architecture - version 8 / 9
Design a mapping to load a target table with the following values from the above source?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Why union transformation is an active transformation?
How we can create indexes after completing the load process?
What are some examples of informatica etl programs?
What is the fact table?
How to use procedural logic inside infromatica?
What is target designer and target load order?
What is a predefined event?
