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

what are the deliverables?in your project?

0 Answers   DELL,

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

Differentiate between source qualifier and filter transformation?

0 Answers  

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

What is Datadriven?

2 Answers   Informatica,

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

Explain the code page compatibility?

0 Answers  

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers