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 ..

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  

in performance wise union is past,union all is past

2 Answers  

What are differences between Informatica 7.1 and 6.1

3 Answers  

How is Data Models Used in Practice?

1 Answers  

What are mapplets?

0 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

How do we call shell scripts from informatica?

0 Answers  

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,