Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 8620 Views
- TCS, I also Faced
- E-Mail Answers
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
Differentiate between a repository server and a powerhouse?
Describe expression transformation?
What do you mean by filter transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
What is domain and gateway node?
How are indexes created after completing the load process?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are active transformations.
What are the designer tools for creating transformations?
As union transformation gives UNION ALL output, how you will get the UNION output?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
what is diff b/t sorter t/r and agg have the option sorter property...
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to update or delete the rows in a target, which do not have key fields?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
