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", "")

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

What are pre and post-session shell commands?

0 Answers  

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

What is Code Page Compatibility?

1 Answers  

what are types of dimentions?

3 Answers  

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,