1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / suresh

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

what is the exact meaning of domain?

3 Answers  

What is update override?

1 Answers   Accenture,

Define maping and sessions?

3 Answers  

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,




What is the surrogate key?

0 Answers  

what is the diff b/w union and joiner and lookup?

4 Answers  

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

Which development components of informatica have the highest usage?

0 Answers  

What do you understand by a term domain?

0 Answers  

For more Informatica Interview Questions Click Here
Categories