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
- 13003 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
How to use pmcmd utility command?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are different types of transformations available in informatica?
What is the difference between stop and abort in informatica
How to extract the informatica rejected data?
I have a flat file, want to reverse the contents of the flat file
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How many ways a relational source definition can be updated and what are they?
What is the session task and command task?
How to load the data from people soft hrm to people soft erm using informatica?
What is a transaction control transformation?
Enterprise data warehouse your projects phase by phase explain?
How to update source definition?
What is mapping debugger?
