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.
Answer Posted / 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 |
Post New Answer View All Answers
Implementation methodology
What is a repository manager?
What all join we can perform in LOOKUP transformation?
What is joiner change?
What are the different versions of informatica?
how tokens will generate?
What is DR strategy for Informatica project?
To import the flat file definition into the designer where should the flat file be placed?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
If informatica has its scheduler why using third party scheduler?
Informatica settings are available in which file?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is powercenter on grid?
How to use procedural logic inside infromatica?