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
- 7812 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 happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
what is informatica metadata?
Difference between Target-based loading and constraint-based loading?
Slowly changing dimensions, types and where will you use them
What is a filter transformation and why it is an active one?
How can one identify whether mapping is correct or not without connecting session?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How many ways are there to create ports?
How do you take back up of repository?
What are the features of complex mapping?
What are the tasks that can be performed using sq?
How do you load only null records into target?
Explain in detail scd type 2 through mapping.
What is the reusable transformation?
