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
- 8686 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / manthiramoorthy. g
S==>SQ===>Exp===>Target
In Exp. Trans.
Create one port.
phone_out =
'('||SUBSTR(phno,1,3)||'-'||SUBSTR(phno,4,3)||'-'||SUBSTR(phno,7)
The Output is: (123)-456-7890
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
what is size of u r database?
Which is the t/r that builts only single cache memory?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
what is diff b/t sorter t/r and agg have the option sorter property...
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain in detail about scd type 1 through mapping.
How can you increase the performance in joiner transformation?
How to configure mapping in informatica?
How to join three sources using joiner?
Where are the source flat files kept before running the session?
What is incremental aggregation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the new features of Power Center 5.0?
Enlist the advantages of informatica.
