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
- 8847 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 the surrogate key?
What are the differences between oltp and olap?
What are the tasks that can be performed using sq?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is depict expression change?
What do mean by local and global repository?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what is informatica metadata?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are the different lookup cache(s)?
tell me the rules and responsblites in our project(my project is development)
What are roles and groups and benefits of using them?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is meant by a domain?
Which transformation should we use to normalise the COBOL and relational sources?
