Answer / ravi

i think the query should be like this
phoneno =
'('||SUBSTR(phno,1,3)||')'||'_'||SUBSTR(phno,4,4)||'_'||SUBSTR(phno,8,3)

Answer / rajesh

select ‘(‘||substr(TNO,1,4)’)’||'_'||substr(TNO,5,3)||'_'||substr(TNO,8,3)) from TABLE_NAME

Answer / manthiramoorthy. g

S==>SQ===>Exp===>Target
In Exp. Trans.

Create one port.
phone_out =
'('||SUBSTR(phno,1,3)||'-'||SUBSTR(phno,4,3)||'-'||SUBSTR(phno,7)

The Output is: (123)-456-7890

Answer / ravikumar2614

phone_no=||'('||substr(pno,1,3)||')-'||substr(pno,4,3)||'-'||substr(pno,8,3)

Answer / dilip ingole

in sql use
SELECT REGEXP_REPLACE('9975344018', '(d{3})(d{3})(d{4})', '(1)-2-3') FROM DUAL;


in informatica also same use REG_REPLACE instead of REGEXP_REPLACE ..

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

what is diff between grep and find

3 Answers   IBM, iFlex,

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

How many joins in Informatica

5 Answers   CSC,

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

What are two types of processes that informatica runs the session?

2 Answers  

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

What aer the out put files that the informatica server creates during the session running?

4 Answers  

in which situations do u go for starflake schema ?

6 Answers   TCS,

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

What is blocking transformation?

0 Answers   Informatica,