i think the query should be like this phoneno = '('||SUBSTR(ph

my source contain data like this
eno ename phno
100 john 9989020508
101 ram 7246599999
i want to load the data into target is
eno name phno
100 john (998)-9020-508
102 ram (724)-6599-999.

Question Posted / ravi

5 Answers
8481 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / ravi

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

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

tell me 5 session failure in real time how can you solve that in your project?

2190

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1054

What is the scenario which compels informatica server to reject files?

1013

Mention few advantages of router transformation over filter transformation.

982

What is flashback table ? Advance thanks

1875

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1936

What is data movement mode in Informatica and difference between them?

1066

How to load a Dimension ? and how to load a fact table?

1374

Define joiner transformation?

992

What is informatica metadata and where is it stored?

938

What are multi-group transformations?

1015

What is the use of transformation?

949

What is the function of aggregator transformation?

1022

Explain the mapping variable usage example in informatica

1090

Explain lookup transformation source types in informatica

1044