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

What are junk dimensions?

0 Answers  


How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,


What are the types of maping wizards that r to be provided in Informatica?

2 Answers  


How would you copy the content of one repository to another repository?

0 Answers  


if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,


Explain the etl program with few examples.

0 Answers  


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

5 Answers   TCS,


what are objects in data warehouse?

2 Answers   Mind Tree,


Categories