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

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;

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

Answer / keshava

Using SQL

SELECT 'vishnraju@gmail', INSTR('vishnraju@gmail', '@'),
SUBSTR('vishnraju@gmail', 1, INSTR('vishnraju@gmail', '@')-
1) FROM DUAL

Answer / bhagyasri

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

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,

Why union transformation is an active transformation?

0 Answers   Informatica,

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

What is IQD file?

1 Answers  

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

Explain the informatica workflow?

0 Answers