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 |
Can you start a batches with in a batch?
What is active and passive transformation?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
Target is zero file and how can you send the email?
What is mapplet and a reusable transformation?
what is the predefined port in dynamic lookup
in which situations do u go for scds ?
Where is metadata stored?
What is a candidate key?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is the significance of newlookup port in dynamic look up
What is up date strategy and what are the options for update strategy?