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
- 13424 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunny
with data as
(
select 'vishnraju@gmail.com' coll from dual
union all
select 'suresh@yahoo.com' col from dual
union all
select 'krishna@hotmail.com' coll from dual
)
select SUBSTR(coll,1,(INSTR(coll,'@')-1)) AS USERNAME from data;
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / priyank
PORT=INPUT("vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com"
VAR_EMAIL_1=SUBSTR(PORT,1,INSTR(PORT,',',1,1)-1)
VAR_EMAIL_2=SUBSTR(PORT,INSTR(PORT,',',1,1)+1,INSTR(PORT,',',1,2)-1)
VAR_EMAIL_3=SUBSTR(PORT,INSTR(PORT,',',1,2)+1)
VAR_NAME_1=SUBSTR(VAR_EMAIL_1,1,INSTR(VAR_EMAIL_1,'@',1)-1)
VAR_NAME_2=SUBSTR(VAR_EMAIL_2,1,INSTR(VAR_EMAIL_2,'@',1)-1)
VAR_NAME_3=SUBSTR(VAR_EMAIL_3,1,INSTR(VAR_EMAIL_3,'@',1)-1)
OUT_PORT=VAR_NAME_1||','||VAR_NAME_2||','||VAR_NAME_3
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / bhagyasri
REPLACE(REPLACE(REPLACE(email_address, "@gmail.com", ""), "@yahoo.com", ""), "@hotmail.com", "")
| Is This Answer Correct ? | 0 Yes | 0 No |
What are multi-group transformations?
Types of error logs in Informatica?
What do you understand by SOA of Informatica?
What is a data modeling?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
How to create the source and target database connections in server manager?
HOW TO GET THE LATEST DATA IN SCD ?
How do you do error handling in Informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
How to do unit testing in informatica? How to load data in informatica ?
what is persistant cache in which situation we will use persistantcache
how to duplicates from expression transformation without using sorter before that
Teradata 
