Interested to Buy Any Domain ? << Click Here >> for more details...
in my source table one of column contains the data like
vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these
records i need to send in target table as below format.
vishnuraju,suresh,krishna
- 5 Answers
- 13212 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / bhagyasri
REPLACE(REPLACE(REPLACE(email_address, "@gmail.com", ""), "@yahoo.com", ""), "@hotmail.com", "")
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the sequence generator transformation in informatica?
What is update strategy transform?
Informatica settings are available in which file?
What is the use of code page?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a difference between complete, stop and abort?
How we can create indexes after completing the loan process?
How to go to the older version for a mapping?
What is session task and command task?
How can we use mapping variables in informatica?
Explain the informatica workflow?
What is the meaning of up gradation of repository?
Where is metadata stored?
What the difference is between a database, a data warehouse and a data mart?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
