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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajesh
select ‘(‘||substr(TNO,1,4)’)’||'_'||substr(TNO,5,3)||'_'||substr(TNO,8,3)) from TABLE_NAME
| Is This Answer Correct ? | 5 Yes | 3 No |
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
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / ravikumar2614
phone_no=||'('||substr(pno,1,3)||')-'||substr(pno,4,3)||'-'||substr(pno,8,3)
| Is This Answer Correct ? | 0 Yes | 1 No |
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 ..
| Is This Answer Correct ? | 0 Yes | 1 No |
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
what is diff between grep and find
How can yoU improve session performance in aggregator transformation?
How many joins in Informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are two types of processes that informatica runs the session?
What are the settings that you use to configure the joiner transformation?
What aer the out put files that the informatica server creates during the session running?
in which situations do u go for starflake schema ?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
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
What is blocking transformation?