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
- 13425 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
How many types of sessions are there in informatica.please explain them?
What is the function of look up transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
How to open an older version of an object in the workspace?
Describe data concatenation?
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 intricate mapping?
Explain target update override in informatica
Explian the Process of deployment groups in informatica
What is the commit type if you have a transaction control transformation in the mapping?
How to extract sap data using informatica? What is abap? What are idocs?
What is a standalone command task?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How are the sources and targets definitions imported in informatica designer?
What is rank transformation in informatica
