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
- 13434 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / keshava
Using SQL
SELECT 'vishnraju@gmail', INSTR('vishnraju@gmail', '@'),
SUBSTR('vishnraju@gmail', 1, INSTR('vishnraju@gmail', '@')-
1) FROM DUAL
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
What is the meaning of decode in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is informatica metadata and where is it stored?
How to generate sequence numbers?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Define joiner transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Can anyone tell me the new features in Informatica 9 Version?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the settings that you use to configure the joiner transformation?
What are session parameters ? How do you set them?
According to his methodology what all you need before you build a datawarehouse
How to do unit testing in informatica?
What is informatica?
