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

Answers were Sorted based on User's Feedback



in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krish..

Answer / rayudu

HI ,

By using substr and instr we can retrive only the name part from the entire string and send to target.

Regrds,
rayudu

Is This Answer Correct ?    8 Yes 2 No

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krish..

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

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krish..

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

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krish..

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

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krish..

Answer / bhagyasri

REPLACE(REPLACE(REPLACE(email_address, "@gmail.com", ""), "@yahoo.com", ""), "@hotmail.com", "")

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


What are the types of metadata that stores in repository?

2 Answers  


my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,


How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  


How many number of sessions can one group in batches?

0 Answers  






What is the sequence generator transformation in informatica?

0 Answers  


There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,


what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


What do think which one is the better joiner or look up?

0 Answers  


Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,


Explain the features of connected and unconnected lookup.

0 Answers  


How do you set a varible in incremental aggregation

0 Answers  


Categories