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

When will you use SQL override in a lookup transformation?

1 Answers  

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

What is standalone command task?

0 Answers  

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

What is domain in terms of informatica?

0 Answers  

How we can create indexes after completing the loan process?

0 Answers