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
- 8683 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
What is an aggregator transformation?
What is the format of informatica objects in a repository?
Why do we need informatica?
How to improve the performance of a session using sorter transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is an expression transformation in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What do mean by local and global repository?
What is informatica powercenter repository?
What is joiner transformation in informatica?
How many ways are there to do 'remove duplicate records in informatica'?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the Rank index port in Rank transformation?
How to load the data from people soft hrm to people soft erm using informatica?
