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
- 8628 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
phone_no=||'('||substr(pno,1,3)||')-'||substr(pno,4,3)||'-'||substr(pno,8,3)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is DR strategy for Informatica project?
Explain pmcmd command usage in informatica
What are the components of workflow manager?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
scenario where i can use only concurrent execution of workflow.
Can we change Dynamic to Static or Persistent cache? If so what happens?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the format of informatica objects in a repository?
State the differences between sql override and lookup override?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Suppose we do not group by on any ports of the aggregator what will be the output?
what is informatica metadata?
